Database AdministratorDesigns, implements and oversees the physical design and operation of the organization's databases in order to maintain security and integrity controls.ResponsibilitiesThe list of essential functions, as outlined herein, is intended to be representative of the duties and responsibilities performed within this classification. It is not necessarily descriptive of any one position in the class. The omission of an essential function does not preclude management from assigning duties not listed herein if such functions are a logical assignment to the position.Oversees operations of on-premises and cloud-based database environments, including production, non-production, and disaster recovery systemsDesigns, implements, and supports hybrid database architectures across on-premises and cloud-based environmentsLeads database migration efforts, including cloud transition strategies with low- to near-zero downtimeImplements and supports data replication, synchronization, and change data capture solutionsDesigns, configures, and supports virtualized database environments with a focus on performance and scalabilityDevelops, maintains, and tests enterprise backup and disaster recovery strategies across hybrid environmentsCollaborates with infrastructure teams to optimize database storage performance across SAN/NAS and cloud-based storage environmentsDesigns and develops advanced SQL solutions, including high-performance stored procedures, indexing strategies, and query tuningBuilds, deploys, and maintains SSIS packages and modern ETL pipelinesImplements and maintains high availability and resiliency solutions, including Always On Availability Groups, clustering, replication, and geo-replicationAutomates database administration, monitoring, deployment, and maintenance processes using scripting and infrastructure automation toolsMonitors system health and performance; proactively resolves bottlenecksEstablishes and enforces database security standards, including encryption, identity integration, and auditingAdvises leadership on data strategy, cloud adoption, and modernization efforts.QualificationsTo perform this job successfully, an individual must be able to perform each essential duty and responsibility satisfactorily.
The requirements listed below are representative of the knowledge, skill, and/or ability required.EDUCATION AND/OR EXPERIENCE:Bachelor's degree in a computer related field from an accredited college or university and six (6) to eight (8) years of experience in related field; or an equivalent combination of education, certification, training, and/or experience.CERTIFICATES, LICENSES, REGISTRATIONS AND DESIGNATIONS:Microsoft Certified: Azure Database Administrator AssociateAzure Data Engineer Associate or AWS equivalentOracle Certified Professional (OCP)Oracle GoldenGate certification preferredKNOWLEDGE, SKILLS AND ABILITIES:Ability to organize work for timely completionAbility to speak, write, read, and understand EnglishAbility to follow complex oral and written instructionsAbility to communicate effectively orally and in writingAbility to establish and maintain effective and cooperative working relationships with those contacted in the course of workSkill in Microsoft Office applicationsSkill using database platforms, including Microsoft SQL Server, Oracle Database, Azure SQL Database, and Amazon RDSSkill using cloud platforms, including Microsoft Azure and Amazon Web ServicesSkill using data integration and replication tools, including Oracle GoldenGate, SQL Server Integration Services, and Azure Data FactorySkill using virtualization technologies, including VMware and Oracle VMSkill using automation, scripting, and infrastructure automation tools, including PowerShell and TerraformAbility to travel up to 10% of the timeAbility to commute with personal transportation.PHYSICAL REQUIREMENTS:The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Ability to exert light physical effort in sedentary to light work, which may involve some lifting, carrying, pushing and/or pulling of objects and materials of light weight (up to 20 pounds).ENVIRONMENTAL REQUIREMENTS:The work environment characteristics described here are representative of those an employee may encounter while performing the essential functions of this job.Functions are regularly performed inside without potential for exposure to adverse conditions, such as inclement weather, atmospheric elements and pathogenic substances. The noise level in the work environment is usually moderate.