| Local to NY-NJ !! Onsite !! SQL DBA !! at Remote, Remote, USA |
| Email: [email protected] |
| From: Shubham Jaiswal, KPG99,INC [email protected] Reply to: [email protected] SQL DBA Client is from Banking domain NO H1B-CPT Please Note this role is on-site only 5 Days a week in New York City during the probation period then Hybrid Must have Banking experience 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: 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. Thanks and Regards, Shubham Jaiswal | Sr. Technical Recruiter | KPG99,INC | MBE Certified Firm | [email protected] | www.kpgtech.com 3240 E State St EXT , Hamilton, NJ 08619 Linkedln : https://www.linkedin.com/in/shubham-jaiswal-b1b02a20b Note: KPG99 does not endorse undesired email. If you do not want to receive our mails, please reply with Remove in the subject; I would ensure that you are not troubled further. I apologize for any inconvenience Keywords: database golang microsoft New Jersey |
| [email protected] View all |
| Thu Feb 01 02:44:00 UTC 2024 |