Senior Database Administrator
Role details
Job location
Tech stack
Job description
Senior Oracle Database Administrator (Sr. DBA) plays a critical role in maintaining and optimizing the databases that support our corporate and municipal clients. This position operates under the guidance of the Database Manager and collaborates closely with cross-functional teams to deliver robust, secure, and scalable database solutions aligned with company initiatives., * Design and implement database architecture on Exadata systems (X4-X10) and Oracle Cloud Infrastructure (OCI).
- Manage Oracle resources on Exadata systems, Autonomous Transaction Processing (ATP-D) , and OCI Goldengate.
- Oversee installation, configuration, patching, upgrades, and maintenance of Oracle databases (19c or later).
- Perform backup and recovery using RMAN, Data Guard, and OCI-native tools.
- Optimize performance-SQL tuning, indexing strategies, execution plan analysis, AWR/ASH reports.
- Configure and maintain Oracle Active Data Guard, and disaster recovery environments.
- Perform duties related to migrating on-prem Oracle databases into the Oracle Gov Cloud infrastructure.
- Develop and maintain Infrastructure as Code (IaC) using Terraform/Resource Manager.
- Implement high availability strategies, autoscaling, and load balancing.
- Enforce database security policies like encryption, auditing, access control, vault key management.
- Manage user roles, privileges, authentication, and identity integration both On-prem and OCI (OCI IAM / IDCS).
- Lead on-premises Oracle DB migrations to OCI using Data Pump / Transportable Tablespaces, GoldenGate, RMAN backup/restore workflows
- Manage OEM environment including patching, upgrades etc.
- Analyze incidents, troubleshoot issues, and implement root-cause fixes, resolve issues with external and internally developed database applications.
- Perform database cloning operations from production to test and development environments on on-prem and OCI autonomous databases.
- Implement DDL/DML scripts in support of SCRUM application release cycles.
- Automate recurring tasks through a combination of SQL, PL/SQL, or scripting languages such as Perl, Bash, OCI CLI, Python, etc.
- Basic knowledge and logical understanding of other databases like PostgreSQL, MySQL, MSSQL, Mongo databases etc.
- Assess and suggest opportunities for application and process improvement
- Promote adherence to departmental/software development standards.
- Promote learning, understanding, and the general enablement of the DBA team.
- Set a professional example for the team through model behavior, superior performance, and proper attendance.
- Managing Transparent Data Encryption (TDE) for both data at rest and data in transit.
Requirements
Do you have experience in Technical troubleshooting support?, Do you have a Bachelor's degree?, * BA in Computer Science or the equivalent combination of education, training, and experience
- 8+ years of Oracle database administration experience, with a focus on both on-prem SQL Server and Oracle Cloud Infrastructure (OCI).
- 3+ years of Oracle cloud Infrastructure (OCI) experience.
- Knowledge of SQL Server, PostgreSQL, and MySQL are preferred.
- Ability to own and manage tasks and/or projects with minimal direction
- Ability to successfully troubleshoot issues/provide solutions with minimal direction
- Ability to learn new technologies/applications with minimal direction
- 'Can do' attitude towards solving problems and completing tasks
- Capable of researching and resolving issues with technologies outside of core competency
- Experience in Oracle RAC, ASM, Exadata (on-prem or cloud),Active Data Guard, Performance tuning, RMAN, OCI Goldengate Replication.
- Strong knowledge of Linux OS administration.
- Strong scripting skills such as OCI CLI, Python, Shell scripting, Perl, etc.
- Backup and all facets of recovery (simple restore, point in time recovery, etc.)
Personal Skills and Attributes
- Capable to research and resolve issues with technologies outside of core competency.
- Strong technical and interpersonal skills with the ability to work with minimal supervision within a global staffing environment.
- Proven analytical/problem solving skills irrespective of database technology.
- Ability to adapt in a dynamic environment.
- Ability to effectively communicate with technical staff (applications development and technical services) and management.
- Keen attention to detail.
- Willing to support operations in a 24X7 environment, ensuring uptime and responsiveness.
- Ability to learn new technologies/applications with minimal direction.
- Extensive experience working in a team-oriented, collaborative environment.
- Must be locally located and comfortable working a 3 days in office hybrid model and 2 days remote.