Database Administrator (Onsite)
About The Position
The Client is seeking an experienced SQL Database Administrator to join a small development team focused on restructuring and modernizing the city's revenue collections systems and related city database environments. The role requires a strong background in database security, backup and recovery, and performance monitoring standards. The Database Administrator establishes and maintains database performance standards, monitors system usage, analyzes performance, and performs optimization to maintain data availability and responsiveness to user queries. The role also maintains data security and integrity standards, implements access levels according to management specifications, diagnoses and resolves performance problems, archives and maintains records, and performs backup and recovery. The position evaluates system and user needs and recommends capacity increases. It also plans and implements database conversions and migrations or upgrades to new database versions and servers, and monitors network traffic and communications usage patterns, configuring or modifying network settings to address system demands and capacity-planning needs.
Requirements
- Bachelor's degree from an accredited college or university in information systems, computer science, or a related field, and two years of experience in database management; an equivalent combination of education and experience is accepted.
- Experience in performance optimization and troubleshooting, and implementing, maintaining, and controlling hierarchical or relational database management systems.
- Strong hands-on experience administering Microsoft SQL Server.
- Knowledge of database development, management, warehousing, and administration principles and practices.
- Knowledge of hierarchical and relational database management system software programming languages and operating system software.
- Knowledge of database security practices for monitoring, controlling, and evaluating user access, logons, permissions, and related variables.
- Knowledge of methods for ensuring, protecting, and resolving problems involving information systems security.
- Knowledge of archival, backup, and recovery methods.
- Skill in developing database queries and generating reports.
- Ability to implement, control, and evaluate database management systems.
- Ability to analyze, apply logic, and solve technology problems.
Nice To Haves
- Experience with Azure SQL Database or Managed Instance, including security administration, monitoring, and backup and recovery in Azure.
- Familiarity with Azure data tools such as Azure Data Factory or Azure Database Migration Service for moving data from legacy systems into SQL Server.
Responsibilities
- Establish and maintain database performance standards; monitor system usage, analyze performance, and optimize systems to maintain data availability and responsiveness.
- Devise and maintain data security and integrity standards, and implement security access levels in accordance with management specifications.
- Diagnose and resolve database system performance problems.
- Archive data, maintain archival and active records, and perform data backup and recovery.
- Evaluate system and user needs and recommend increased system capacity.
- Plan and implement database conversion projects and the migration and upgrade of databases to new versions and servers.
- Monitor network traffic and communications usage patterns, and configure or modify network settings to meet system demands and capacity-planning needs.
- Interview users and gather information for database query systems, report generation, database model design, and upgrades.
- Prepare user documentation and train users in database capabilities and procedures for accessing data.
- Establish and maintain effective working relationships with vendors, management, technical co-workers, support specialists, and system users.
