What are the responsibilities and job description for the Database Administrator position at DeKalb County Government?
Job Description
Salary Range $64,893 - $104,479 Pay Grade: 21 Job Code: 16055 FLSA Status: Exempt
This opening is in the department of Planning & Sustainability.
Essential Functions
The following duties are normal for this position. The omission of specific statements of the duties does not exclude them from the classification if the work is similar, related, or a logical assignment for this classification. Other duties may be required and assigned.
Develops plans and requirements for new systems and enhancements; translates requirements into physical database structures; develops, designs and reviews data models; consults with application development teams; performs routine audits of database inventory; surveys and audits the enterprise network; meets with users and project managers to gather requirements for new systems and projects; and coordinates with infrastructure technicians to monitor and adjust storage and infrastructure related resources.
Monitors the state of County databases; evaluates performance, capacity and reliability of databases; runs scripts to capture database bottlenecks and poorly performing reports and queries; manages disk space for database systems; runs scripts to optimize indexes and check database integrity; implements efficiency improvements where needed; adjusts resource usage as needed; and analyzes database code written by developers to assess impact on the database system and application performance.
Installs, configures, and maintains database management software, including upgrades, patches, and third-party tools; performs database backup and database recovery; and schedules routine restoration of sample backup files to test file integrity.
Maintains user and data security; adds users and user groups; assigns users to database sources; determines appropriate levels of data access; connects users to requested database; ensures data security through standard server security best practices; and monitors and upgrades database server security during maintenance activities.
Selects or assists in the selection of new database management and application systems; analyzes systems design, feasibility, cost, impact, hardware specifications, data conversion functions, and reduction of redundant data; reviews configuration and deployment plans for performance, maintainability, scalability, and conformance to architectural standards; and makes appropriate recommendations.
Develops or validates deployment scripts for database software changes; deploys databases and database changes in testing, training, preproduction, and production environments; writes stored procedures, functions, triggers, and batch jobs in the database
Maintains an awareness of new applications, technologies, technical methods, trends, and advances in the profession; reviews professional publications, technical manuals, and websites to increase knowledge of network operations; and attends conferences, workshops, and training sessions as appropriate.
Minimum Qualifications
Bachelor's Degree in Computer Science, Management Information Systems, or related field required; five years of progressively responsible experience in database administration and design in a large-scale information technology environment; or any equivalent combination of education, training, and experience which provides the requisite knowledge, skills, and abilities for this job.
Specific License or Certification Required: Must possess and maintain a valid Georgia driver’s license.
Salary Range $64,893 - $104,479 Pay Grade: 21 Job Code: 16055 FLSA Status: Exempt
This opening is in the department of Planning & Sustainability.
Essential Functions
The following duties are normal for this position. The omission of specific statements of the duties does not exclude them from the classification if the work is similar, related, or a logical assignment for this classification. Other duties may be required and assigned.
Develops plans and requirements for new systems and enhancements; translates requirements into physical database structures; develops, designs and reviews data models; consults with application development teams; performs routine audits of database inventory; surveys and audits the enterprise network; meets with users and project managers to gather requirements for new systems and projects; and coordinates with infrastructure technicians to monitor and adjust storage and infrastructure related resources.
Monitors the state of County databases; evaluates performance, capacity and reliability of databases; runs scripts to capture database bottlenecks and poorly performing reports and queries; manages disk space for database systems; runs scripts to optimize indexes and check database integrity; implements efficiency improvements where needed; adjusts resource usage as needed; and analyzes database code written by developers to assess impact on the database system and application performance.
Installs, configures, and maintains database management software, including upgrades, patches, and third-party tools; performs database backup and database recovery; and schedules routine restoration of sample backup files to test file integrity.
Maintains user and data security; adds users and user groups; assigns users to database sources; determines appropriate levels of data access; connects users to requested database; ensures data security through standard server security best practices; and monitors and upgrades database server security during maintenance activities.
Selects or assists in the selection of new database management and application systems; analyzes systems design, feasibility, cost, impact, hardware specifications, data conversion functions, and reduction of redundant data; reviews configuration and deployment plans for performance, maintainability, scalability, and conformance to architectural standards; and makes appropriate recommendations.
Develops or validates deployment scripts for database software changes; deploys databases and database changes in testing, training, preproduction, and production environments; writes stored procedures, functions, triggers, and batch jobs in the database
Maintains an awareness of new applications, technologies, technical methods, trends, and advances in the profession; reviews professional publications, technical manuals, and websites to increase knowledge of network operations; and attends conferences, workshops, and training sessions as appropriate.
Minimum Qualifications
Bachelor's Degree in Computer Science, Management Information Systems, or related field required; five years of progressively responsible experience in database administration and design in a large-scale information technology environment; or any equivalent combination of education, training, and experience which provides the requisite knowledge, skills, and abilities for this job.
Specific License or Certification Required: Must possess and maintain a valid Georgia driver’s license.
Salary : $64,893 - $104,479
