|
Hi,
Please look at the requirements below, let us know of your interest, and send us your updated resume to [email protected]
Role: SQL DBA with SSIS, SSRS and production Support Experience
Location: Woodland Hills, CA/ Richmond, VA, Atlanta, GA- Remote
Job Description:
Production Support Specialist
Position Overview:
The ideal candidate will possess extensive experience in managing enterprise-level applications and databases with expertise in MSSQL, SSIS, SSRS, and BC Generator. This role involves ensuring the seamless operation of critical systems, supporting key projects, and maintaining compliance with audit and regulatory requirements.
The candidate will be responsible for administering and optimizing production environments, participating in architecture reviews, and ensuring successful deployments, upgrades, and migrations. You will work closely with cross-functional teams to troubleshoot issues, enhance performance, and deliver high-quality support to meet organizational objectives.
Key Responsibilities:
1. Project and Technology Support:
• 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.
2 Patching and Vulnerability Management:
• Perform weekly Client patch support to ensure systems are updated and secure.
• Execute vulnerability remediation processes to address identified risks and maintain system integrity.
3 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.
4 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.
5 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.
6 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.
7 Deployment and Maintenance:
• Support CNR deployments, ensuring smooth implementation with minimal disruptions.
• Document and maintain Standard Operating Procedures (SOPs) for recurring tasks and processes.
8 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.
9. 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.
Mandatory Skill Sets:-
• 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 Client patch support, vulnerability remediation, and system upgrades.
• Strong background in performance tuning and optimization of applications, databases, and system processes.
• Demonstrated experience in incident management, including root cause analysis, SWAT call participation, and problem resolution.
• Knowledge of application/technology license management and compliance with licensing agreements.
• Familiarity with audit controls execution, preparation of audit evidence packages, and adherence to regulatory standards.
• Experience participating in architecture reviews, design discussions, and monthly planning meetings with development teams.
• Strong analytical and troubleshooting skills, with the ability to address complex technical issues efficiently.
• Excellent documentation skills for creating and maintaining SOPs and technical process records.
• Effective communication and collaboration skills to work as a liaison between cross-functional teams and stakeholders.
With Regards
Kishore Reddy
|
