SQL DBA (SQL Server/Azure SQL)

Trigyn Technologies Limited.; Baltimore (MD); Hybrid; USD 90,000 - 150,000; Full time

Job summary

Trigyn Technologies, Inc. in Baltimore, MD is seeking an experienced SQL Database Administrator to join a small development team focused on restructuring and modernization of revenue collections systems and other database environments.

The role requires strong database security, backup and recovery capabilities, along with performance monitoring and system optimization, MS SQL Server expertise, and experience with Azure SQL and related data tools.

Qualifications

• Bachelor's degree in information systems, computer science or related field preferred.
• Strong experience administering Microsoft SQL Server environments.
• Experience with Azure SQL, security administration, backup and recovery.
• Familiarity with data migration and database performance tuning.

Responsibilities

• Establishes and maintains database performance standards; monitors usage and optimizes systems.
• Implements data security access levels and monitors permissions.
• Diagnoses and resolves database performance problems.
• Manages data backup, archival and recovery processes.
• Plans and executes database conversion projects and migrations.
• Monitors network traffic and configures networks to meet capacity needs.

Skills

SQL Server

Azure SQL

Database security

Backup and recovery

Performance tuning

Data migration

Education

Bachelor's degree in information systems or computer science

Tools

Azure Data Factory

Azure SQL Database

SQL Server Management Studio

Job description

Trigyn's direct government client has a contract opportunity for a SQL DBA in Baltimore, MD (HYBRID Position)

Description:

The client is seeking an experienced SQL Database Administrator to be part of a small development team focusing on the restructuring and modernization of the revenue collections systems and other related database environments. The candidate must have a strong background in database security, backup and recovery, and performance monitoring standards.

Database Administrator responsibilities may include but are not limited to the following:

• Establishes and maintains database performance standards; monitors system usage; analyzes database performance and performs system optimization tasks to maintain data availability and ensure system responsiveness to user queries.
• Devises and maintains data security and integrity standards; implements security access levels in accordance with management specifications.
• Diagnoses and resolves database system performance problems.
• Archive data; maintains archival and active records; performs data back-up and recovery.
• Evaluates system and user needs and makes recommendations for increased system capacity.
• Plan and implement database conversion projects and the migration and upgrade of databases to new versions and servers.
• Monitors network traffic and communications usage patterns; configures or modifies network configuration to meet system demands and capacity planning needs.

Required Skills, Knowledge and Abilities

• Knowledge of principles and practices of database development, management, warehousing and administration.
• Knowledge of hierarchical and relational database management system software programming languages.
• Knowledge of operating system software.
• Knowledge of database security practices to monitor, control and evaluate user access, logons, permissions and related variables.
• Knowledge of methods for ensuring, protecting and resolving problems involving the security of information systems.
• Knowledge of archival, back-up 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/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.
• Skill in developing database queries and generating reports.
• Ability to interview users and extract pertinent information for development of database query system and report generation, database model design and upgrades.
• Ability to implement, control and evaluate database management systems.
• Ability to prepare user documentation and train users in 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 and support specialists, and system users.

Minimum Education and Experience Requirements:

• A bachelor's degree from an accredited college or university in information systems, computer science or a related field and strong experience in database management including performance optimization and troubleshooting, and implementing, maintaining and controlling hierarchical or relational database management systems.

Equivalencies:

• An equivalent combination of education and experience.

BALTIMORE CITY RESIDENTS STRONGLY ENCOURAGED TO APPLY.

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 27001:2022 and CMMI Level 5 certified company.