Job Description

Primary Responsibilities

• Administer and support enterprise Microsoft SQL Server 2012+ and Oracle 10g+ database environments.
• Perform database installation, configuration, upgrades, maintenance, monitoring, and operational support.
• Manage backup, recovery, disaster recovery, security, and access controls.
• Monitor and optimize database performance through indexing, query optimization, capacity planning, and performance tuning.
• Design, develop, and maintain secure and efficient relational database structures.
• Apply database design principles, normalization, indexing strategies, and performance optimization techniques.
• Support enterprise-scale production databases and ensure high availability, reliability, and performance.
• Analyze business requirements and translate them into effective database solutions.
• Develop database specifications, technical documentation, and implementation plans.
• Troubleshoot complex database issues and perform root-cause analysis.
• Evaluate alternative technical solutions and recommend appropriate remediation strategies.
• Support Snowflake, data warehousing, and relational data platforms as required.
• Collaborate with BI and analytics teams supporting Power BI, SQL, DAX, semantic models, and reporting environments.
• Support ESRI SDE Geodatabases and GIS data management requirements.
• Communicate technical concepts and recommendations effectively to technical and non-technical stakeholders.
• Estimate effort, timelines, and resource requirements for database initiatives.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Information Technology, or a related field; equivalent professional experience may be considered.
• 5+ years of combined experience supporting enterprise database environments.
• Expert-level experience administering Microsoft SQL Server 2012 and later versions.
• Hands-on experience administering Oracle Database 10g and later versions.
• Strong experience with:
  • Database installation and configuration
  • Backup and recovery
  • Performance tuning and optimization
  • Database security and access controls
  • Production database support
  • Database monitoring and troubleshooting
• Strong understanding of relational database management, database design, normalization, and indexing.
• Experience designing, developing, and maintaining relational database structures.
• Ability to independently diagnose and resolve complex database issues.
• Strong analytical, problem-solving, documentation, and communication skills.

Preferred Qualifications

• Experience with Azure SQL Database.
• Experience with AWS database technologies and SQL services.
• Experience administering ArcGIS Server environments.
• Experience with enterprise data warehouse environments.
• Knowledge of cloud database migration and modernization practices.

Job Tags

Similar Jobs