| Hybrid : Applications SQL DBA No H1b at NYC, New York, USA |
| Email: [email protected] |
| Client: Banking Title: Applications SQL DBA ( Banking / 30TB and larger databases ) Location: NYC NY-local candidate Duration: 12 months Visa: No H1B MOI: Skype Need Linkedin while submisison Our Client is seeking consultants who 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. Design indexes for existing applications, choosing when to add or remove indexes. Seeking Applications DBA, not just a production DBA Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc). Consultant must have experience: 1) 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. 2) Designing tables and picking datatypes o Using Profiler traces and other tools to find the most frequently run queries. 3) Using free tools like sp_BlitzIndex and DMV queries to answer questions about index usage. 5) On-call troubleshooting for SQL Server service outages. 6) Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem. Skills Need: Must have 4 + 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. -- Keywords: database information technology golang microsoft New York |
| [email protected] View all |
| Thu Feb 22 02:10:00 UTC 2024 |