Local or Nearby Candidate Only// Urgently Looking For SQL DBA/ DataBase Administrator// NYC, NY (Onsite)// Banking Client
Role: SQL DBA/ DataBase Administrator
Location: Midtown NYC, NY (Onsite/ Local or nearby Only)
Duration: 12+ Months
Client: Banking Client
Visa: No H1b/ OPT/ CPT
Process: Phone/ Skype
We need professionals with 10+ years of experience working as an SQL DBA and 6+ years of recent banking experience. If you have experience working with 30+ TB databases and 5+ years of experience in Database Performance Tuning, we want to hear from you!
Our Client, is seeking consultants that will participate on a Global DBA team. The team will ensure that the new database code meets company standards for readability, reliability, and performance. This role is on-site in their New York City office for the first 4 months, following that is remote.
• Design indexes for existing applications, choosing when to add or remove
indexes.
• Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc).
• Consultant must have experience:
• Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions.
• Designing tables and picking datatypes
• Using Profiler traces and other tools to find the most frequently run queries.
• Using free tools like sp_BlitzIndex and DMV queries to answer questions about
index usage.
• On-call troubleshooting for SQL Server service outages.
• Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
Skills Need:
• Must have 6 + years of Recent Banking experience.
• Must have recent and extensive experience performing Level 3 support (The highest-level Support).
• These positions are for a Global DBA unit. Consultants must have experience working Constantly with DBs sizes of 30TB or more
• Experience working with large-scale enterprise application setup across Data centers.
• Must have a Minimum of 10+ years conducting general database administration tasks (e.g. DB
implementation, DB code deployments, DB backups, creation of DB user accounts).
• Minimum of 7+ years experience working as a SQL Server DBA.
• Must have experience as an Functional & Application DBA.
• Must have at least 5 years administering database platform specific advanced features
(e.g. clustering, encryption, logical/physical standby, ETL, replication) and performance optimizing server database servers and SQL code.
• Minimum of 5+ years experience working in a SQL DBA Role with multiple databases and SQL development experience.
• Proficient in MS SQL Server 2014 - 2019.
• SSIS Package creation and debugging skills.
• Stored procedure development and tuning.
• Data replication exposure
