| SQL DBA II Princeton, NJ II Contract at Princeton, New Jersey, USA |
| Email: [email protected] |
| Kindly share only the local profile of New jersey. Title: SQL DBA Location: 3 days on-site, 2 days remote , Princeton, NJ Duration: 6 mths - 1 yr Location: We are looking for an individual with 3-5 yrs experience SUMMARY The SQL DBA is responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems to ensure the availability and consistent performance of our corporate applications. This position requires solid technical skills, as well as excellent interpersonal and communication skills. The SQL DBA is responsible for the development and sustainment of the SQL Server Eco-System, ensuring its operational readiness (security, health, and performance), executing data loads, and performing data modeling in support of multiple development teams. The incumbent will also develop and manage a robust data warehouse to support a suite of program management tools. Job Requirements KNOWLEDGE AND SKILL REQUIREMENTS/COMPETENCIES 3+ years MS SQL Server Administration experience required. 3+ years w/ Development and integration of SQL database services in an enterprise environment. 3+ years working w/large databases (1 TB+). 3+ years working in a clustered Windows environment. 3+ years w/ SQL Server Integration Services (SSIS). 3+ years w/ SQL Server Reporting Services (SSRS). MCTS, MCITP, and/or MVP certifications a plus. A working knowledge of Salesforce/MuleSoft/Snowflake would be a plus. Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. Experience with backups, restores and recovery models. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server. Excellent written and verbal communication. Flexible, collaborator, get-it-done personality. Ability to organize and plan work independently. Ability to work in a rapidly changing environment. Ability to multi-task and context-switch effectively between different activities and teams Experienced in Database Performance, Maintenance and Development to perform the following: o Database management including backups, recovery, and maintenance. o Database management for export, import and mass data loads. o Analyzes and generation of all tables and index statistics. o Monitoring and resolving data lock issues. o Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions, and background processes. o Create indexes to achieve critical dataset response time for time sensitive reports. o Install SQL Server service packs and updates. o Configure and manage SQL Security settings. o Manage database backup & recovery & DR planning in collaboration with IT manager and System Engineer. o Create, modify, and optimize SQL Server Agent jobs and maintenance plans. Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs, and resolve issues in a timely manner. Insight Troubleshoot application slowness and performance issues. o Perform SQL Server integration with enterprise applications. o Experienced in Database Design and Development to perform the following: New projects database design utilizing o SQL Stored procedures development, compilation and debugging. -- Keywords: information technology microsoft New Jersey SQL DBA II Princeton, NJ II Contract [email protected] |
| [email protected] View all |
| Sat May 18 01:22:00 UTC 2024 |