SQL Database Administrator

Cynet Systems • Baltimore, MD

2d

About The Position

The SQL Database Administrator will join a small development team focused on restructuring and modernizing revenue collections systems and related database environments. The role requires a strong background in database security, backup and recovery, and performance monitoring. The administrator will maintain database performance, availability, security, and integrity; troubleshoot and optimize systems; and support database capacity planning, conversions, migrations, and upgrades.

Requirements

• Bachelor's degree from an accredited college or university in information systems, computer science, or a related field, and two years of database management experience, including performance optimization and troubleshooting and implementing, maintaining, and controlling hierarchical or relational database management systems; an equivalent combination of education and experience is accepted.
• 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 information systems security and protecting against and resolving security problems.
• Knowledge of archival, backup, and recovery methods.
• Strong hands-on experience administering Microsoft SQL Server.
• Experience with Azure SQL (Azure SQL Database or Managed Instance), including security administration, monitoring, and backup and recovery in Azure.
• Skill in developing database queries and generating reports.
• Ability to interview users and gather information for database query systems, report generation, database model design, and upgrades.
• Ability to implement, control, and evaluate database management systems.
• Ability to prepare user documentation and train users on database capabilities and procedures for accessing data.
• Ability to analyze, apply logic, and solve technology problems.
• Ability to establish and maintain effective working relationships with vendors, management, technical co-workers, support specialists, and system users.

Nice To Haves

• 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 to user queries.
• Develop and maintain data security and integrity standards, and implement security access levels according to management specifications.
• Diagnose and resolve database system performance problems.
• Archive data and maintain archival and active records; perform data backup and recovery.
• Evaluate system and user needs and recommend increased system capacity.
• Plan and implement database conversions 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level