Description

Key Responsibilities

• Perform day-to-day database administration for SQL Server, Oracle, and GIS databases.
• Design, implement, maintain, and optimize enterprise database structures.
• Monitor database health, troubleshoot issues, and perform performance tuning.
• Conduct SQL code reviews and recommend best practices.
• Develop and maintain database administration procedures and technical documentation.
• Support database activities for application enhancements, upgrades, and modernization initiatives.
• Assist in database architecture, schema design, and data warehousing initiatives.
• Support enterprise database security and compliance standards.
• Collaborate with Project Managers, Business Analysts, Data Analysts, and application development teams.
• Mentor junior database administrators and technical staff.
• Analyze business processes and workflows to develop efficient database solutions.
• Prepare technical specifications and database documentation.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent professional experience).
• Minimum 5 years of combined database administration experience supporting enterprise environments.
• Expert-level experience with:
  • Microsoft SQL Server 2012 and newer
  • Oracle Database 10g and newer
• Strong experience with:
  • Database design
  • Performance tuning
  • Database security
  • Backup and recovery
  • Database monitoring
  • SQL optimization
  • Database troubleshooting
  • Enterprise production support

Preferred Skills

Candidates with experience in the following will be highly preferred:

• Azure SQL
• AWS database services/tools
• ESRI ArcGIS Server administration
• GIS and Spatial Databases
• ESRI SDE Geodatabases
• Data Warehousing
• Enterprise Database Architecture
• Database Capacity Planning
• Database Standards and Governance
• Infrastructure Support
• Database Automation

Technical Skills

• SQL Server Administration
• Oracle Database Administration
• SQL Performance Tuning
• Query Optimization
• Database Monitoring
• Database Backup & Recovery
• High Availability
• Database Security
• Database Schema Design
• Relational Database Design
• Data Modeling
• Data Warehousing
• SQL Code Reviews
• Database Documentation
• Database Migration
• Enterprise Production Support
• GIS Database Administration
• ArcGIS Server
• ESRI SDE

Key Skills

Education

Bachelor's degree