Sr. Oracle DBA

Sr. Oracle DBA

Location: Miami, Florida or Dallas, Texas.

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.