Senior Database Administrator

Title: Senior Database Administrator

Duration: 12 Months Contract, Hybrid, 2 times a week minimum onsite

Location: Taylor, TX 76574

Shift Timing (Day/ Evening/ Night): Day

Summary:

• Provides advanced database administration across SQL Server, Oracle, and PostgreSQL platforms supporting Client's grid and market systems, delivering expert-level operational support across the full service lifecycle for the duration of the contract.
• This contract role serves as a hands-on operational delivery resource, executing complex and standard database work, receiving escalations, and providing technical guidance to peers as needed. The role owns advanced troubleshooting, escalation handling, replication management with a strong emphasis on Oracle GoldenGate, proactive monitoring and tuning through Oracle Enterprise Manager (OEM), performance optimization, and disaster recovery execution.
• Success in this position requires a dependable team player and quick learner who ramps rapidly on Client's tools, standards, and change processes; collaborates effectively across application, infrastructure, and compliance teams; and works with appropriate autonomy to coordinate operational changes within Client's regulated environment.

Role & Responsibilities:

• Provides advanced troubleshooting and resolution of database outages, performance degradation, replication failures, backup exceptions, and availability events across SQL Server, Oracle, and PostgreSQL databases supporting grid and market systems, using diagnostic tools, vendor support, and cross-team coordination as needed.
• Administers and supports Oracle GoldenGate replication, including heterogeneous configurations across Oracle, SQL Server, and PostgreSQL, performing extract/replicate monitoring, lag analysis, conflict detection and resolution, trail management, and switchover support to maintain continuous data availability.
• Supports high-availability and disaster-recovery configurations across platforms, including Oracle Data Guard, SQL Server Always On Availability Groups, and PostgreSQL streaming replication and high-availability clustering, including failover preparation, execution, and post-event validation.
• Performs proactive database monitoring, analysis, and tuning using Oracle Enterprise Manager (OEM), Oracle Automatic Workload Repository and Active Session History, SQL Server Management Studio, and PostgreSQL monitoring tooling; identifies and resolves query performance issues, resource contention, and capacity constraints before they affect service availability.
• Executes backup and recovery operations and disaster recovery activities for assigned databases, ensuring Rubrik Cloud Data Management, together with native backup utilities across SQL Server, Oracle (Recovery Manager), and PostgreSQL, meets defined RPO and RTO targets and that recovery procedures are tested and validated on schedule.
• Plans and executes database patching, security updates, and version upgrades across all three platforms through the ServiceNow change management process, including risk assessment, testing coordination, rollback planning, and post-change validation.
• Coordinates schema changes with application development teams, including index optimization, deployment sequencing, and environment refresh activities to support grid and market application release cycles.
• Supports database access reviews, least-privilege enforcement, and compliance evidence collection for NERC CIP and SOC audit requirements; serves as a knowledgeable resource for compliance assessments related to the database service area.
• Develops automation using Ansible, Python, shell scripting, PowerShell, PL/SQL, and Transact-SQL to reduce recurring manual tasks; contributes to infrastructure-as-code practices using Terraform and Git within the team's established standards where applicable.
• Operates as an active, dependable team member who learns Client tools and processes quickly, shares knowledge openly, and provides technical guidance and cross-training to peers and junior staff as needed.

Required Skills:

• Performs assigned database tasks during monthly data center site switchover exercises, coordinating failover execution, replication validation, and post-switchover verification.
• Maintains and improves knowledge articles, runbooks, operational standards, and support documentation used by the team and adjacent responders.
• Manages incidents, service requests, and change records within ServiceNow, and coordinates vendor support tickets escalated through Oracle, Microsoft, and PostgreSQL support channels, tracking resolution through completion.
• Contributes to capacity planning and lifecycle management activities by analyzing database growth trends, storage utilization, and platform lifecycle timelines.
• Participates in incident post-mortem reviews and contributes to root cause analysis and corrective action planning for significant database events.
• Provides knowledge transfer and cross-training to team members and operational partners to build depth and reduce single points of knowledge within the department.

Required Experience:

• Five to eight years of progressively responsible experience in database administration in multi-platform environments involving Oracle, SQL Server, and PostgreSQL.
• Experience must include hands-on Oracle GoldenGate replication administration and proactive monitoring and tuning through Oracle Enterprise Manager (OEM).
• Experience should also include advanced troubleshooting, high-availability and disaster-recovery management, backup and recovery, performance tuning, and patching coordination in a production environment supporting business-critical applications.
• Proficiency with scripting and automation, including Python and shell scripting, is required.
• Demonstrated ability to ramp quickly in a new environment and to collaborate effectively as part of a team is essential for this contract role.
• Experience in a regulated environment subject to NERC CIP or SOC is strongly preferred, and experience with configuration-management and infrastructure-as-code tools such as Ansible and Terraform, along with familiarity with the ServiceNow IT service management platform, is a plus.

Education:

• Bachelor's degree in Computer Science, Information Technology, Information Systems, or related field; or equivalent combination of education and experience.

Preferred Certifications:

• Oracle Certified Professional – Database Administration
• Oracle GoldenGate certification or demonstrated equivalent experience
• Microsoft Certified: Azure Database Administrator Associate
• PostgreSQL certification (e.g., EDB PostgreSQL Associate/Professional) or demonstrated equivalent experience
• HashiCorp Terraform Associate or equivalent infrastructure-as-code certification.

About our Company: -

22nd Century Technologies, Inc., is one of the fastest growing IT Service Integrator and Workforce Solution companies in the United States. Founded in 1997, 22nd Century Technologies is a Certified National Minority Business Enterprise with 6,000+ people including 600+ Cyber SMEs nationwide supporting our customers in all 50 states, Canada, and Mexico. With HQs in Somerset, NJ and Mclean, VA, 22nd Century has 14 offices throughout the United States. As part of our unrelenting focus on quality and compliance, 22nd Century Technologies delivery is based on Certified Matured Processes including CMMI L3 Dev & SVC, ISO 20000, ISO 27001, and ISO 9001 quality processes. With a strong focus on the public sector, 22nd Century currently holds government contracts with 14 out of 15 Federal Executive agencies including DoD, 37 other Federal agencies, 50 States, 115+ Local agencies, and 37 School Districts. In the last three years, we have expanded our services to Fortune 500 and other commercial clients and currently support 80+ commercial clients.

Recognized among Best Company to Work For by Forbes, 22nd Century Technologies, Inc., consistently exceeds our clients expectations by focusing on their absolute satisfaction with jobs while keeping our employees motivated. 22nd Century Technologies is an Equal Opportunity Employer" and s & all other parties authorized to work in the US are encouraged to apply."

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.