Database Architect

Responsibilities

• Establish standards and practices to configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
• Onboard and operationalize new businesses brought on by acquisition in order to bring them up to our standard and ensure that they can scale
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
• Identify new opportunities and help refine automation of regular processes, track issues, and document changes
• Work in an Agile Scrum or equivalent models
• Solve/Assist in complex query tuning and schema refinement
• Expert in troubleshooting performance issues
• Join the on-call rotation with other Engineers
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members

Skills and Qualifications

• 12+ years of experience writing performant/maintainable/scalable SQL
• 6+ years MS SQL Server experience required
• Matured experience in T-SQL and scripting skills.
• Advance knowledge of Query Optimizer and query performance tuning
• Working knowledge of SQL Server Internals, wait types, scheduling, etc.
• Working knowledge of query parallelism and worker thread utilization
• Working experience in Windows Clustering, partitioning, purging concepts
• Knowledge of Microsoft Azure Cloud (IAAS)
• Excellent written and verbal communication
• Ability to organize and plan work independently is critical.
• Ability to work in a rapidly changing environment
• Ability to multi-task and context-switch effectively between different activities and teams
• Knowledge on Microsoft cloud managed DBs/Systems, e.g. Managed SQL Instance, Azure SQL DB etc. will be a big plus
• .NET or other object-oriented development experience a big plus
• Domain knowledge and experience in the banking/fintech industry is a plus