What are the responsibilities and job description for the Oracle DBA: Miami, Florida or Dallas, Texas :: Fulltime position at SS33 Business Services LLC?
Position: Lead Oracle DBA
Location: Miami, Florida or Dallas, Texas.
Fulltime
Client TechMahindra-Salary : $100,000/Annum
Shorter Version Of JD
A senior Oracle DBA is responsible for migrating, upgrading, designing oracle databases that meet the business requirements and specifications. This involves creating logical and physical data models, defining data structures and relationships, setting up database parameters and options, and implementing best practices and standards for database development. A senior oracle DBA also uses various tools and languages, such as SQL, PL/SQL, SQL*Plus, SQL Developer, and Oracle Data Modeler, to create, modify, and test database objects, such as tables, views, indexes, triggers, procedures, functions, and packages.
Detailed JD
Assess database performance
Implement security measures for computer or information systems
Develop computer or information security policies or procedures
Update computer database information
Create databases to store electronic data
Set database parameters or specifications
Write computer programming code
Develop guidelines for system implementation
Develop performance metrics or standards related to information technology
Coordinate project activities with other personnel or departments
Read documents to gather technical information
Estimate time or monetary resources needed to complete projects
Train others in computer interface or software use
Coordinate software or hardware installation
Develop detailed project plans
Analyze data to identify trends or relationships among variables
Analyze market or customer related data
Develop models of information or communications systems
Key Responsibilities Of a Senior Oracle DBA
Database Design and Implementation:
Architecting and designing new Oracle databases to meet business requirements, including data modeling, schema creation, and normalization.
Implementing database upgrades, migrations, and patching across different Oracle versions.
Performance Optimization
Monitoring database performance metrics to identify bottlenecks and implement tuning strategies like index optimization, query optimization, and SQL tuning.
Analyzing database usage patterns and proposing performance improvements.
Backup And Recovery
Developing and maintaining robust backup and recovery procedures for critical production databases.
Managing data replication and disaster recovery strategies.
Security Management
Implementing and enforcing database security policies, including user access controls, data encryption, and auditing procedures.
Identifying and mitigating potential security vulnerabilities.
Capacity Planning
Monitoring database storage usage and proactively planning for future capacity needs.
Analyzing database growth trends and recommending scaling solutions.
Troubleshooting And Support
Diagnosing and resolving complex database issues, including performance degradation, data corruption, and application errors.
Providing technical support to application developers and other stakeholders.
Team Leadership And Mentorship
Leading and mentoring junior DBAs on best practices, database administration tasks, and troubleshooting techniques.
Sharing knowledge and expertise within the database team.
Required Skills And Experience
Deep expertise in Oracle Database Administration:
Extensive knowledge of Oracle database concepts, features, and administration tools.
SQL And PL/SQL Proficiency
Strong ability to write complex SQL queries and PL/SQL procedures for data manipulation and automation.
Performance Tuning Skills
Proven experience in identifying and resolving database performance bottlenecks.
Backup And Recovery Expertise
Thorough understanding of Oracle backup and recovery mechanisms.
Database Security Knowledge
Familiarity with database security best practices and implementation techniques.
Problem-solving And Analytical Skills
Ability to troubleshoot complex database issues and provide effective solutions.
Strong Communication Skills
Effective communication with technical and non-technical stakeholders to understand requirements and explain complex database concepts.
Location: Miami, Florida or Dallas, Texas.
Fulltime
Client TechMahindra-Salary : $100,000/Annum
Shorter Version Of JD
A senior Oracle DBA is responsible for migrating, upgrading, designing oracle databases that meet the business requirements and specifications. This involves creating logical and physical data models, defining data structures and relationships, setting up database parameters and options, and implementing best practices and standards for database development. A senior oracle DBA also uses various tools and languages, such as SQL, PL/SQL, SQL*Plus, SQL Developer, and Oracle Data Modeler, to create, modify, and test database objects, such as tables, views, indexes, triggers, procedures, functions, and packages.
Detailed JD
Assess database performance
Implement security measures for computer or information systems
Develop computer or information security policies or procedures
Update computer database information
Create databases to store electronic data
Set database parameters or specifications
Write computer programming code
Develop guidelines for system implementation
Develop performance metrics or standards related to information technology
Coordinate project activities with other personnel or departments
Read documents to gather technical information
Estimate time or monetary resources needed to complete projects
Train others in computer interface or software use
Coordinate software or hardware installation
Develop detailed project plans
Analyze data to identify trends or relationships among variables
Analyze market or customer related data
Develop models of information or communications systems
Key Responsibilities Of a Senior Oracle DBA
Database Design and Implementation:
Architecting and designing new Oracle databases to meet business requirements, including data modeling, schema creation, and normalization.
Implementing database upgrades, migrations, and patching across different Oracle versions.
Performance Optimization
Monitoring database performance metrics to identify bottlenecks and implement tuning strategies like index optimization, query optimization, and SQL tuning.
Analyzing database usage patterns and proposing performance improvements.
Backup And Recovery
Developing and maintaining robust backup and recovery procedures for critical production databases.
Managing data replication and disaster recovery strategies.
Security Management
Implementing and enforcing database security policies, including user access controls, data encryption, and auditing procedures.
Identifying and mitigating potential security vulnerabilities.
Capacity Planning
Monitoring database storage usage and proactively planning for future capacity needs.
Analyzing database growth trends and recommending scaling solutions.
Troubleshooting And Support
Diagnosing and resolving complex database issues, including performance degradation, data corruption, and application errors.
Providing technical support to application developers and other stakeholders.
Team Leadership And Mentorship
Leading and mentoring junior DBAs on best practices, database administration tasks, and troubleshooting techniques.
Sharing knowledge and expertise within the database team.
Required Skills And Experience
Deep expertise in Oracle Database Administration:
Extensive knowledge of Oracle database concepts, features, and administration tools.
SQL And PL/SQL Proficiency
Strong ability to write complex SQL queries and PL/SQL procedures for data manipulation and automation.
Performance Tuning Skills
Proven experience in identifying and resolving database performance bottlenecks.
Backup And Recovery Expertise
Thorough understanding of Oracle backup and recovery mechanisms.
Database Security Knowledge
Familiarity with database security best practices and implementation techniques.
Problem-solving And Analytical Skills
Ability to troubleshoot complex database issues and provide effective solutions.
Strong Communication Skills
Effective communication with technical and non-technical stakeholders to understand requirements and explain complex database concepts.
Salary : $100,000
