Senior SQL Database Administrator

## **Position Overview:** 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. **Essential Responsibilities:** - 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. **Qualifications:** - 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.) - Successful completion of the Nlets fingerprinting background assessment. **Personal Skills and Attributes** - Capable to research and resolve issues with technologies…