Database Administrator

Job Description: Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected., * Provide advanced SQL and PL/SQL coding expertise, including writing and optimizing functions, procedures, and packages.

• Review, analyze, and test code written by others to ensure performance, scalability, and adherence to best practices.
• Support application developers with SQL design and data access strategies.

Database Architecture & Design

• Collaborate with the Information Technology Solutions Architect to design robust database solutions that support enterprise applications and system interfaces across diverse platforms.
• Lead the development and enforcement of database policies, procedures, and standards related to stored procedures, packages, and functions.
• Plan and design database hosting architecture in alignment with State standards, strategic direction, and business requirements.
• Provide technical leadership in the design and management of physical database structures to ensure optimal performance and scalability.

Database Administration & Maintenance

• Install, configure, and maintain SQL Server instances across development, test, and production environments.
• Perform regular backups, restores, and recovery testing to ensure data integrity and availability.
• Monitor and maintain database performance, availability, and security using tools such as SSMS, SQL Server Agent, and third-party monitoring solutions (e.g., SolarWinds, Redgate, Idera).
• Manage indexes, partitions, statistics, and schema parameters to support peak performance.
• Apply patches, updates, and version upgrades as needed.

Monitoring, Troubleshooting & Support

• Proactively identify and resolve performance bottlenecks and system alerts.
• Analyze logs, trace data, and performance metrics to diagnose and resolve issues.
• Collaborate with IT and DevOps teams to ensure server stability and uptime.
• Oversee the creation and validation of physical database components (e.g., tables, indexes, triggers, constraints) and coordinate initial server and file system setup.

Data Integrity, Security & Governance

• Implement and manage user roles, permissions, and access controls.
• Ensure compliance with data security policies, standards, and industry best practices.
• Participate in disaster recovery planning and high availability strategies.
• Develop and enforce database models, access controls, and documentation standards.
• Work with data warehouse teams to support data transfer and transformation processes.

Years of Experience 12 - 14 years of experience in the field, * Strong proficiency in T-SQL and PL/SQL, with expertise in query optimization and performance tuning.

• Experience with SQL Server Management Studio (SSMS), SQL Server Agent, and monitoring tools such as SolarWinds, Redgate, or Idera.
• Solid understanding of database security, backup strategies, recovery models, and high availability configurations.
• Familiarity with ETL processes, PowerShell scripting, and/or Azure SQL is a plus.
• Proven ability to enforce development standards across teams.
• Soft skills: Communication

Required/Must Have:

• SQL: 10 Years
• PowerShell: 6 Years
• Azure DevOps: 6 Years
• Scrum: 6 Years