Senior Database Administrator
About The Position
TekWissen is recruiting a Senior Database Administrator for its client, which operates the Texas power grid. The role provides advanced database administration across SQL Server, Oracle, and PostgreSQL platforms supporting grid and market systems. It is a hands-on operational delivery position responsible for work across the service lifecycle, complex troubleshooting, escalations, replication management—with particular emphasis on Oracle GoldenGate—monitoring and tuning through Oracle Enterprise Manager, performance optimization, and disaster recovery. The administrator will learn the client’s tools, standards, and change processes quickly, collaborate with application, infrastructure, and compliance teams, and coordinate operational changes within a regulated environment. The assignment is temporary, lasts 12 months, and is hybrid in Taylor, Texas. The position also participates in monthly data center site switchover exercises, maintains operational documentation, manages records and incidents through ServiceNow, coordinates vendor support, contributes to capacity and lifecycle planning, and participates in post-mortems and knowledge transfer.
Requirements
- Five to eight years of progressively responsible database administration experience in multi-platform environments involving Oracle, SQL Server, and PostgreSQL.
- Hands-on Oracle GoldenGate replication administration experience.
- Experience with proactive monitoring and tuning through Oracle Enterprise Manager (OEM).
- Experience with advanced troubleshooting, high availability and disaster recovery, backup and recovery, performance tuning, and patching coordination in production environments supporting business-critical applications.
- Proficiency with scripting and automation, including Python and shell scripting.
- Ability to ramp up quickly in a new environment and collaborate effectively as part of a team.
- Bachelor’s degree in Computer Science, Information Technology, Information Systems, or a related field, or an equivalent combination of education and experience.
Nice To Haves
- Experience in a regulated environment subject to NERC CIP or SOC requirements.
- Experience with configuration-management and infrastructure-as-code tools such as Ansible and Terraform.
- Familiarity with ServiceNow.
- Oracle Certified Professional – Database Administration certification.
- Oracle GoldenGate certification or demonstrated equivalent experience.
- Microsoft Certified: Azure Database Administrator Associate certification.
- PostgreSQL certification, such as EDB PostgreSQL Associate/Professional, or demonstrated equivalent experience.
- HashiCorp Terraform Associate certification or equivalent infrastructure-as-code certification.
Responsibilities
- Troubleshoot and resolve database outages, performance degradation, replication failures, backup exceptions, and availability events across SQL Server, Oracle, and PostgreSQL.
- Administer Oracle GoldenGate replication, including heterogeneous configurations, monitoring extract and replicat processes, analyzing lag, resolving conflicts, managing trails, and supporting switchovers.
- Support high-availability and disaster-recovery configurations, including Oracle Data Guard, SQL Server Always On Availability Groups, and PostgreSQL streaming replication and clustering; prepare, execute, and validate failovers.
- Monitor, analyze, and tune databases using Oracle Enterprise Manager, Oracle AWR and ASH, SQL Server Management Studio, and PostgreSQL monitoring tools; address query performance, resource contention, and capacity constraints.
- Execute backup, recovery, and disaster-recovery activities, using Rubrik Cloud Data Management and native platform utilities, and ensure recovery procedures meet targets and are tested and validated on schedule.
- Plan and execute database patching, security updates, and version upgrades through ServiceNow change management, including risk assessment, testing coordination, rollback planning, and post-change validation.
- Coordinate schema changes with application development teams, including index optimization, deployment sequencing, and environment refreshes.
- Support database access reviews, least-privilege enforcement, and compliance evidence collection for NERC CIP and SOC audits; provide database-service expertise for compliance assessments.
- Develop automation using Ansible, Python, shell scripting, PowerShell, PL/SQL, and Transact-SQL, and contribute to Terraform and Git infrastructure-as-code practices where applicable.
- Learn client tools and processes, share knowledge, and provide technical guidance and cross-training to peers and junior staff.
- Perform assigned database work during monthly data center site switchover exercises, including failover execution, replication validation, and post-switchover verification.
- Maintain and improve knowledge articles, runbooks, operational standards, and support documentation.
- Manage incidents, service requests, and change records in ServiceNow; coordinate and track vendor support tickets through resolution.
- Contribute to capacity planning and lifecycle management by analyzing database growth, storage utilization, and platform lifecycle timelines.
- Participate in incident post-mortems and contribute to root-cause analysis and corrective action planning.
- Provide knowledge transfer and cross-training to team members and operational partners.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
