| SQL Server DBA ||Princeton Onsite at Remote, Remote, USA |
| Email: [email protected] |
| From: Garima, TEK Inspirations LLC [email protected] Reply to: [email protected] position L3 Support SQL Server DBA Location Princeton Onsite Duration: 6 month Visa: USc,GC,GCEAD, h4EAD Need linkedin JobDescription: Must have 10 years of experience working for US companies. Must have 4 years of 'Recent' Banking experience (Since 2016). Must have recent experience performing Level 3 support (The highest-level Support). These positions are for a 'Global' unit. Consultants must have experience working 'Constantly' with DB's of 30TB or more (Not Less). 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 a 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. Indexes: When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes. Conduct SQL Server lunch-and-learn sessions for application developers. 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 willbe known amongst the office as the go-to person for T-SQL questions. 2) Designing tables and picking datatypes of Using Profiler traces and othertools to find the most frequently run queries. 3) Using free tools like sp_BlitzIndex and DMV queries to answer questionsabout index usage. 4) On-call troubleshooting for SQL Server service outages. 5) Deciding whether clustering, log shipping, mirroring, replication, etc arethe right fit to solve a business problem. MINIMUM QUALIFICATIONS Bachelor's Degree in relevant domain is required, or Master's level degreepreferred. Keywords: database information technology golang green card microsoft |
| [email protected] View all |
| Tue Feb 07 00:58:00 UTC 2023 |