Job Description
Posting expires: April 14, 2025
General Description and Classification Standards
Plans computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines, and protection. This is a fully seasoned professional level capable of independently carrying out most assignments typical of the profession. This level would be attainable by multiple incumbents in a work group (not necessarily by all), but would not be an "automatic" promotional level.
Supervision Received
Works under very general supervision. Depending on the organizational structure, may work independently with responsibility for an assigned function or program.
Responsibilities
Essential Duties and Responsibilities:
These are typical responsibilities for this position and should not be construed as exclusive or all inclusive.
• Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries, and establishes and maintains security and integrity controls.
• Formulates and monitors policies, procedures, and standards relating to database management.
• Proposes and implements enhancements that will improve the performance and reliability of the system.
• Selects from multiple procedures and methods to accomplish tasks.
• Applies organizational policies; may interpret organizational policies and recommend exceptions.
• Establishes work methods, timetables, performance standards, etc.
• Routinely provides work group leadership, guidance, and/or training to less experienced staff.
• Allocates and optimizes system storage for the database system.
• Conducts capacity planning.
• Plans future storage requirements and advises management on long-term capacity plans and growth of the database system.
• Designs, implements, and maintain database security protocol. Plans and coordinates security measures alongside network administrators. Identifies and rolls out best practices for security, user and password management.
• Establishes and maintains sound backup and recovery policies and procedures. Defines Data Archive/Purge Standards. Monitors and maintains backups and recovery operations for database systems.
• Monitors and optimizes the performance of the database. Performs accurate application tuning and performance monitoring. Ensures availability of the database. Uses non-disruptive administration tactics.
• Manages and enforces database policies, procedures, and standards. Performs tests and evaluations regularly to ensure data security, privacy, and integrity.
• Collaborates with the Applications team to develop database solutions by designing the proposed system; defining database physical structure, security, back-up, and recovery specifications.
• Documents database policies, procedures, and standards.
• Identifies and builds various database reports needed to give visibility into critical database and server parameters.
• Deploys and installs Oracle and SQL Server databases.
• Designs and optimizes database architecture for performance and scalability.
• Documents database systems and operational procedures.
• Monitors and tunes database performance, identifying and resolving issues.
• Assists the Innovations team by providing knowledge and skills for data analytics, visualizations, power BI reporting, implementing data lakes and data warehouses.
• Troubleshoots and resolves database-related problems.
• Trains and mentors junior and support staff.
• May act as team lead.
• May perform other duties as assigned.
The above statements reflect the general duties, responsibilities and competencies considered necessary to perform the essential duties and responsibilities of the job and should not be considered as a detailed description of all the work requirements of the position. COA may change the specific job duties with or without prior notice based on the needs of the organization.
Knowledge Skills and Abilities:
This is a partial listing of necessary knowledge, skills, and abilities required to perform the job successfully, it is not an exhaustive list.
• Extensive knowledge of concepts, processes, and tools of the profession.
• Knowledge of the relationship of professional discipline among related organizations and functions.
• Well-developed technical skills within the profession.
• Skills in organizing and presenting proposals or information.
• Ability to plan and carry out virtually any typical assignment within the professional area.
• Ability to train others.
• Ability to build effective relationships within the organization.
Qualifications
Minimum Qualifications
Education and Experience - Bachelor's Degree in Business Information Systems, Computer Science, or related discipline -and five (5) years of directly related professional database experience.
Licensures and Certifications
None required.
Preferred Requirements
Master's Degree in Business Information Systems, Computer Science, or related discipline with -six (6) years of experience.
Work Environment:
Required physical, lifting, and sensory capabilities are requirements to perform the job successfully. Typical environmental conditions associated with the job.
Lifting Requirements:
Sedentary work: Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.
It is the policy of the City of Atlanta ("COA") that qualified individuals with disabilities are not discriminated against because of their disabilities regarding job application procedures, hiring, and other terms and conditions of employment. It is further the policy of the COA to provide reasonable accommodations to qualified individuals with disabilities in all aspects of the employment process. The COA is prepared to modify or adjust the job application process or the job or work environment to make reasonable accommodations to the known physical or mental limitations of the applicant or employee to enable the applicant or employee to be considered for the position he or she desires, to perform the essential functions of the position in question, or to enjoy equal benefits and privileges of employment as are enjoyed by other similarly situated employees without disabilities, unless the accommodation will impose an undue hardship. If reasonable accommodation is needed, please contact the Human Resources Director for your department.
The City of Atlanta is an Equal Opportunity Employer and does not unlawfully discriminate on the basis of race, color, religion, age, disability, sex, sexual orientation, ender identity, marital status, veteran's status or national origin, or any other basis prohibited by federal, state, or local law. We value and encourage diversity in our workforce.
Date Posted: 07 April 2025
Apply for this Job