Hi,
Hope you are doing well!
We have an opportunity for a SQL DBA with one of our clients.
Please see the job details below and let me know if you would be interested in this role.
If interested, please send me a copy of your resume, your contact details, your availability and a good time to connect with you.
Job Role – SQL DBA with SSIS, SSRS and production Support Experience – Production Support Specialist
Location- 100% Remote
Type- Long-Term Contract
Implementation Partner: UST Global
End Client: Elevance Health
Note – H1B and OPT only with 9+ months of validity remaining (Passport number mandatory). The candidate must have one project with Healthcare client. Max rate is $53/Hr on C2C (All inclusive)
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 Intel 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 Intel 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.
Thanks & Regards,
Mayank Jaiswal| Senior Talent Acquisition Specialist
Amaze Systems Inc
USA: 8951 Cypress Waters Blvd, Suite 160, Dallas, TX 75019
Canada: 55 York Street, Suite 401, Toronto, ON M5J 1R7
D: +1 (469) 208-1428
E: [email protected] | www.amaze-systems.com/
USA | Canada | UK | India
Amaze Systems is an Equal Opportunity Employer (EOE), and does not discriminate based on age, gender, religion, disability, marital status, race and also adheres to laws relating to non-discrimination on the basis of national origin and citizenship status.
To unsubscribe from future emails or to update your email preferences click here