Database Administrator

Database Administrator

Project: M&O Services for DSS Application Systems Position Numbers: 57, 58, and 59 Job Titles: Database Administrator 1, Database Administrator 2, and Database Administrator 3

Required: 2 Professional References

Position Summary

The Database Administrator will support the administration, maintenance, performance, availability, security, and technical architecture of enterprise database environments for the M&O Services for DSS Application Systems project. This position requires extensive experience supporting Microsoft SQL Server and other enterprise database technologies, including database configuration, performance tuning, high availability, replication, capacity planning, reporting, and troubleshooting.

The Database Administrator will work collaboratively with application developers, technical architects, infrastructure teams, and other stakeholders to maintain reliable database environments and support enterprise applications and services.

Essential Duties and Responsibilities

• Administer, configure, maintain, and troubleshoot enterprise database environments, including Microsoft SQL Server, Oracle, Sybase, and DB2.
• Install, configure, upgrade, patch, and maintain database management systems and related products.
• Develop and optimize advanced SQL queries and analyze query execution plans to identify and resolve performance issues.
• Perform database and application performance monitoring, tuning, and optimization.
• Configure, support, and troubleshoot SQL Server Always On High Availability environments.
• Support database replication, log shipping, database mirroring, backup, recovery, and other availability and disaster recovery processes.
• Perform database capacity planning and monitor database growth, utilization, and performance.
• Create, maintain, and monitor database users, roles, permissions, and access controls.
• Develop, maintain, troubleshoot, and optimize SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) packages and solutions.
• Utilize PowerShell and scripting technologies to automate database administration and operational activities.
• Support database environments hosted on Microsoft Windows Server, Linux, and UNIX operating systems.
• Develop and maintain database scripts using SQL, PL/SQL, and UNIX Shell Scripting.
• Support data modeling activities, including Star Schema and Snowflake Schema modeling.
• Utilize database administration and development tools such as SQL Developer, TOAD, SQLPlus, SQLLoader, DBArtisan, SSMA, and related technologies.
• Support data integration, reporting, and business intelligence technologies, including Informatica, BusinessObjects, Oracle Reports, and IBM Cognos.
• Support enterprise applications developed using Cúram V7 and Cúram Enterprise Framework Components.
• Collaborate with technical teams supporting Cúram technologies, including Intelligent Evidence Gathering (IEG/IEG2) and Cúram Express Rules for Triage (CERT).
• Work with application and integration technologies including HTML, DHTML, JavaScript, Java frameworks, Struts, Spring, Ajax, jQuery, Dojo, SOA, and Web Services.
• Support enterprise middleware and development technologies such as WebSphere, ESB/Message Broker, Eclipse, and JIRA.
• Assist with database migrations, upgrades, integrations, and application deployments.
• Diagnose and resolve complex database, application, and infrastructure-related issues.
• Maintain technical documentation related to database architecture, configurations, procedures, and operational standards.
• Follow established security, development, change-management, and database administration standards.

Required Qualifications

Candidates must have a minimum of six (6) years of relevant professional experience and demonstrated experience across applicable database administration and enterprise application technologies, including:

• Microsoft SQL Server, including versions 2008/2008 R2, 2012, 2014, 2016, 2019, and/or 2022
• Advanced SQL querying and query execution plan analysis
• Database performance tuning and monitoring
• SQL Server Always On High Availability
• Database replication
• Log shipping and database mirroring
• Database capacity planning
• Database user and role administration
• SSIS and SSRS
• Microsoft PowerShell
• Windows Server environments, including Windows Server 2016, 2019, and/or 2022
• Oracle, Sybase, and/or DB2 database technologies
• SQL and PL/SQL
• UNIX Shell Scripting
• Linux and UNIX environments
• Database backup, recovery, availability, and troubleshooting
• Enterprise database administration and technical architecture

Additional Technical Experience

Depending on project assignment, experience with the following technologies may also be required:

• Oracle 9i, 10g, and 11g
• Sybase 12.5
• DB2 UDB
• SQL Developer, TOAD, SQLPlus, and SQLLoader
• DBArtisan, Perforce, PVCS, SSMA, and RGS
• Informatica
• BusinessObjects
• Oracle Reports
• IBM Cognos
• MS Visio
• Star Schema and Snowflake Schema modeling
• Cúram V7
• Cúram Enterprise Framework Components
• Cúram Intelligent Evidence Gathering (IEG/IEG2)
• Cúram Express Rules for Triage (CERT)
• HTML, DHTML, and JavaScript
• Java frameworks, including Struts and Spring
• Ajax, jQuery, and Dojo
• SOA and Web Services
• WebSphere
• ESB or Message Broker
• Eclipse
• Atlassian JIRA

Preferred Qualifications

• Cúram V7 Certified Developer certification or equivalent Cúram development experience.
• Experience working within enterprise technical architecture environments.
• Experience supporting large-scale, mission-critical application and database environments.
• Experience working with both legacy and modern database platforms.
• Strong knowledge of database high availability, disaster recovery, and business continuity practices.
• Experience supporting database migrations and modernization initiatives.

Core Competencies

• Strong database administration and troubleshooting skills.
• Strong analytical and problem-solving abilities.
• Ability to diagnose complex database performance and availability issues.
• Strong understanding of database security and access management.
• Ability to manage multiple priorities in a production support environment.
• Strong written and verbal communication skills.
• Ability to collaborate effectively with database, application, infrastructure, and business teams.
• Strong attention to detail and commitment to system reliability and data integrity.