What success looks like in this role:
SUMMARY:
Unique opportunity for an Experienced SQL Database and Application Engineer within the Financial Services Industry where you will be required to have S trong SQL Platform operational experience as well as strong experience with SSIS packages, stored procedures and business data flows .
1. Manage the SQL databases, SSIS and other data packages, ensure robust proactive monitoring and alerting is in place.
2. Review and enhance existing SSIS packages, stored procedures and functions.
3. Build new SSIS packages to meet business requirements.
4. Responsible to perform ongoing regular SQL platform maintenance include Security patching, backups, cluster administration, log shipping.
5. Proactively monitor the SQL Platform, tune and enhance.
6. Troubleshooting failed SQL processes and procedures, remediation of any data issues and engagement with 3rd Parties where required.
7. Analyze existing queries and identify performance improvement opportunities.
8. Develop SQL Platform configuration standards.
9. Perform and enhance SQL Platform Disaster Recovery testing and validation procedures.
10. Respond to incidents & requests promptly and resolve within SLA.
11. Proactively contribute to innovation and automation thereby improving the business value and quality of the IT platform overall.
12. Perform RCA of incidents and work towards permanent resolution.
13. Ensure technical documentation is updated and maintained to a high standard for all databases and applications in confluence.
14. Develop and maintain relations with key internal and external stakeholders.
15. Completion of allocated project work within agreed timeframes.
16. Development of high-quality database solutions that are secure, efficient and resilient.
17. Perform application deployment releases into UAT and Production environments.
#LI-AS1
You will be successful in this role if you have:
18. 10+ years’ experience working in a similar role preferably within financial services industry .
19. Proven experience proactively enhancing database platform stability, security and automation capabilities.
20. Strong technical and troubleshooting skills in Microsoft SQL from 2008 to 2022, SSRS, SSIS.
21. Proven experience in stored procedure development .
22. Extensive experience with ETL data flows and data normalisation procedures
23. Extensive experience with managing business data flows in complex financial systems
24. Monitoring and improving SQL Query performance optimisation, indexing and performance monitoring.
25. Proven experience with DR exercises for SQL Platforms.
26. Developing SQL scripts, programs, databases.
27. Being in the financial services industry, adherence to our security and compliance procedures including timely completion of all required training is critical.
Unisys is proud to be an equal opportunity employer that considers all qualified applicants without regard to age, caste, citizenship, color, disability, family medical history, family status, ethnicity, gender, gender expression, gender identity, genetic information, marital status, national origin, parental status, pregnancy, race, religion, sex, sexual orientation, transgender status, veteran status or any other category protected by law.