IT Database Administrator

POSITION SUMMARY:

The Database Administrator, under the direction of the IT Systems Manager is responsible for all SOS databases, which include, but is not limited to, all MS SQL databases, Postgres (PGSQL) database, and MySQL databases. This position requires independent judgment with respect to complex systems and security issues that impact SOS-wide operations.

ESSENTIAL DUTIES and RESPONSIBILITIES:

• Responsible for day-to-day support of database related technologies.
• Develop processes for optimizing database queries, performance, and security according to established best practices.
• Identifies and revives key baseline statistics for database monitoring.
• Analyzes database performance on a routine basis, identifying any potential problem areas.
• Manage database access according to least privilege and zero-trust security principles.
• Install, upgrade, and manage database applications.
• Diagnose and troubleshoot database errors.
• Research, recommend, and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboards.
• Create automations for repetitive database tasks.
• Facilitates limited workstation support to include advanced configuration of systems, advanced installations, troubleshooting and user training/support.
• Resolves problems in an expeditious manner and makes recommendations for other changes as appropriate.
• Ideally will mentor other IT staff to achieve the desired outcomes in support of a 24x7 environment supporting Secretary of State functions.
• Ensures appropriate status and detailed updates are provided to stakeholders where needed.
• Assumes ultimate responsibility for resolving complex system problems, which require extensive research and analysis or originating new techniques due to technological developments.
• Reviews and consults on requirements for systems hardware and network purchases.
• Participates in activities of hardware, software, telecommunications, support, and training vendors.
• Integrates with the Information Security team as needed for investigations and inquiries pertaining to infrastructure security and privacy.
• Provides user support, training, and technical assistance to entire organization.
• Provides on-call support to DoIT staff and agency customers.
• Maintains diagrams and documentation for configuration management and audit purposes including, but not limited to procedures, database functionality, application ownership, etc.
• Performs vulnerability scanning on critical systems regularly and report gaps to appropriate team leads.
• Interfaces and performs daily tasks assisting the administration of IT services.
• Maintain logs related to database security operations as well as maintenance, change and repair records.
• Plan, coordinate, and implement database security measures to protect data, software, and hardware.
• Contribute to the safe, fair, and secure elections for the citizens of Georgia.
• Other duties as assigned.

Knowledge, Skills and Abilities:

• Strong command of SQL and SQL server tools, including, but not limited to, SSRS, SSIS, SSAS, T-SQL, SQL Server Agent, etc.
• Familiarity with AWS RDS a plus
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• Strong familiarity with a scripting and automation technology, which can include Powershell, Bash, Python, Ansible, Terraform, etc.
• Familiarity with monitoring tools such as Prometheus, Grafana, Telegraf, InfluxDB, Zabbix, etc. a plus
• Strong mathematical and statistical knowledge
• Advanced ability to communicate clearly and effectively, both orally and in writing.
• Advanced communication, analytical, and problem-solving skills
• Advanced ability regarding documentation, management, and maintaining the database environment for both internal and external server infrastructures
• Excellent customer service to both internal customers and external
• Track record of successful leadership of projects and operations in an enterprise IT organization.
• Demonstrated leadership and project and personnel management skills.
• Self-managed, upholding timelines, critical dates, and meeting deadlines.
• Strong analytical and problem-solving skills.
• Ability to work with minimal supervision, exercise discretion, and use independent judgment.

SUPERVISION REQUIREMENTS: 0

MINIMUM QUALIFICATIONS:

• AS degree in Computer Science, Management Information Systems, Engineering, or another related field
• One to three years of experience in database administration, information technology, database architecture, or a related field
• Experience with Windows Server environments required and experience with Linux server environments a plus.
• Extensive experience with database technologies (MS SQL required, MySQL/MariaDB, PostgreSQL, etc. a plus)
• Experience with cloud services (AWS, Microsoft Azure, SalesForce) a plus.

Licenses and Certifications:

• MCSE/MCSA certifications preferred.
• Cloud certifications (AWS, Microsoft Azure, SalesForce) a plus.
• Valid Class C Georgia Driver's License and satisfactory motor vehicle record.

PREFERRED QUALIFICATIONS:

• Bachelor's degree from a nationally accredited university in Computer Science, Information Systems, or related field
• 3-5 years of hands-on database administration experience.
• In-depth knowledge of MS SQL best practices highly desirable.

This is a hybrid position - up to two (2) days remote.

Bachelor's degree in a related field and one year of related field Or Associate's degree and three years of related experience Or Four years of related experience

Additional Information

• Agency Logo: Requisition ID: INF02MV
• Number of Openings: 1
• Advertised Salary:85,000.00 -90,000.00 -BOE
• Shift: Day Job
• Posting End Date: Jul 23, 2024