Senior MySQL Database Administrator

TekSynap•Suitland, MD

3h•Onsite

About The Position

We are seeking a Senior MySQL Database Administrator to provide advanced database administration, performance tuning, and operational support for Oracle MySQL environments supporting mission-critical Census Bureau systems. TekSynap is a fast growing high-tech company that understands both the pace of technology today and the need to have a comprehensive well planned information management environment. “Technology moving at the speed of thought” embodies these principles – the need to nimbly utilize the best that information technology offers to meet the business needs of our Federal Government customers. The U.S. Census Bureau (USCB) is the nation’s leading source of high-quality data on the population and economy, supporting evidence-based decision-making across the Federal Government, industry, and the public. To sustain and modernize its data infrastructure, the Census Bureau is establishing an enterprise Database Center of Excellence (DCoE) to centralize and standardize database administration services across the organization. Census Bureau systems operate within a complex, heterogeneous IT ecosystem that includes multiple operating systems, database technologies, and deployment models. This position works collaboratively with program offices, infrastructure teams, and cybersecurity stakeholders to ensure consistent, secure, and reliable database services across the enterprise

Requirements

Five (5) or more years of hands-on experience as a MySQL Database Administrator supporting enterprise and production database environments. Experience must include MySQL installation, configuration, maintenance, performance tuning, troubleshooting, and operational support in a multi-tiered environment.
A Bachelor’s Degree in Computer Science or a related technical field is required.
Fifteen (15) years of applicable experience may be substituted for degree requirements.
U.S. Citizenship
Clearance: Public Trust – Moderate Risk

Nice To Haves

Minimum five (5) years of experience performing database administration duties, specializing inOracle MySQL.
Strong experience supporting MySQL databases (8.x or higher) in enterprise production environments.
Excellent SQL skills, including writing complex queries and working with database objects such as tables and views.
Experience with database performance tuning and optimization techniques.
Hands-on experience supporting large-scale, multi-tiered database environments.
Experience with MySQL product troubleshooting and advanced problem resolution.
Experience configuring and administering MySQL databases on Linux platforms.
Experience with operating systems including Sun Solaris 10.0 or later and Red Hat Linux 6.x or later.
Ability to work independently with minimal supervision.
Strong oral and written communication skills.

Responsibilities

Provides senior-level administration and operational support forOracle MySQLdatabases in large, multi-tiered production environments.
Performs installation, configuration, patching, upgrades, monitoring, and maintenance of MySQL databases (8.x or higher).
Provides 24x7 production and on-call troubleshooting support to ensure database availability and performance.
Performs advanced database performance tuning, including query optimization, indexing strategies, and capacity planning.
Develops and supports complex SQL queries and database objects such as tables, views, and stored routines.
Supports database backup, recovery, and disaster recovery operations to ensure data integrity and resilience.
Troubleshoots MySQL database issues and performs root cause analysis and resolution of database-related incidents.
Supports MySQL database environments running on Linux and UNIX-based operating systems, including Sun Solaris and Red Hat Linux.
Works directly with onsite and offsite customers to gather requirements, analyze needs, and implement effective database solutions.
Collaborates with application teams, system administrators, and cybersecurity personnel to support secure database operations.
Documents database configurations, standards, procedures, and operational activities in accordance with DCoE policies.
Works independently while providing technical guidance to junior and mid-level database administrators as needed.