SQL DBA

Skills

Description

Bachelor’s degree in computer science, Information Technology, Engineering, or a related field.
4+ years of experience in production support for enterprise systems, with a focus on application and database management.
Hands-on experience with MSSQL, including database administration, query optimization, and backup management.
Proficiency in SSIS for data integration, ETL workflows, and automation of business processes.
Extensive experience with SSRS for creating reports, dashboards, and visual analytics to support decision-making.
Expertise in using BC Generator for generating and managing business-critical data processes.
Proven ability to manage patching processes, including Intel patch support, vulnerability remediation, and system upgrades.

Responsibilities

• Manage production support for funded and unfunded projects, ensuring timely delivery of tasks and resolution of issues.
• Provide administrative support for technologies and applications, including installation, upgrades, and migrations.
• Act as a liaison between Business and IT Dev Teams to facilitate smooth communication and problem resolution.
• Patching and Vulnerability Management:
• Perform weekly Intel patch support to ensure systems are updated and secure.
• Execute vulnerability remediation processes to address identified risks and maintain system integrity.
• System and Application Administration:
• Manage database backups, ensuring availability and reliability of data in compliance with organizational policies.
• Oversee application/technology license management, ensuring compliance with licensing agreements.
• Conduct performance tuning and optimization of applications and databases for improved efficiency.
• Monitoring and Incident Management:
• Configure and monitor new alerts and agents to proactively identify and address issues.
• Participate in SWAT calls and problem management activities to resolve critical incidents and minimize downtime.
• Collaboration and Governance:
• Coordinate and participate in architecture reviews and design discussions to ensure alignment with technical standards.
• Engage in monthly PO meetings with GBD IT Dev Teams to discuss priorities, challenges, and updates.
• Audit and Compliance:
• Prepare and maintain audit evidence packages to demonstrate compliance with internal and external regulatory requirements.
• Execute audit controls to ensure operational adherence to established guidelines and standards.
• Deployment and Maintenance:
• Support CNR deployments, ensuring smooth implementation with minimal disruptions.
• Document and maintain Standard Operating Procedures (SOPs) for recurring tasks and processes.
• Development and Reporting:
• Leverage MSSQL, SSIS, and SSRS for data integration, reporting, and dashboard creation to support operational insights. • Utilize BC Generator to facilitate business-critical processes and data generation.
• Problem Solving and Optimization:
• Conduct root cause analysis for recurring issues and implement long-term solutions.
• Optimize existing processes for improved system and application performance.