| SQL DBA - Hybrid - Sacramento, CA at Sacramento, California, USA |
| Email: [email protected] |
|
Processing description: http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2203729&uid= From: Yuvraj, Absolute IT [email protected] Reply to: [email protected] SQL DBA Hybrid - Sacramento, CA AREA From May onwards contractors on the this engagement are now required to return to the office for two days a week, specifically on Monday and Tuesday. Job Description IMPORTANT INFO: DBA candidates must have installed MS SQL server, SSMS, SSIS on their PC/laptop. Any free version for MS SQL server would suffice. Candidate to provide some of the answers by demoing the activity that is being discussed during the ZOOM interview. Candidate must be able to manage / maintain large production databases. Interview time: 1 hour Required Skills: 5 to 9 years of experience with Microsoft SQL Server (MS SQL Server);Database Administration; Database Design; Database development; SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS) Role Description: * Database Administrator and SQL developer with 7 years of experience and expert-level skill in development, analysis, architecture, design, installation, configuration, operation, and maintenance of information systems hardware and software. * Expert-level skill and knowledge and experience in DDL, DML, Physical and Logical Data Modeling (w/UML), Stored Procedures, DB Index Management, Normalization and de-normalization, Data replication, Reporting, ETL, database design, development, and administration-related concepts, methods, and tools * Expert-level skill and knowledge and experience in Data Warehouse concepts, including data mining, data marts, on-line analytical processing (OLAP), etc. * Expert-level skill and knowledge and experience in Microsoft SQL Server, Business Intelligence Solutions, SQL Server Monitoring/Performance tools, Database security and integrity * Resolve database performance and capacity issues, and replication and other distributed data issues. * Determine and implement appropriate change management policies and processes. * Install, configure, test/benchmark, and maintain the general health of database servers and related infrastructure, monitor system logs for alerts, errors and warnings, and available/free space on the OS and storage volumes, and analyze space usage history and recommend changes as needed. * Create/update documentation for new/existing maintenance and installation processes. * Advanced T -SQL, Power skills. * Deep familiarity with SQL Server tools, e.g. SSMS, SQL Profiler, Database Tuning Advisor, SQL Server Configuration Manager, DMVs, Extended Events, etc. * Proven database maintenance skills (backups, index defragmentation, database integrity checks). * Execute ETL tasks in support of data loads. * Troubleshoot and resolve issues. * Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server. Kind Regards, Yuvraj Singh| Absolute IT | Technical Recruiter 116 Village Blvd Suite 200 Princeton New Jersey 08540 Absolute IT Direct: (609) 736 2818 Office: 201-228-3009 EXT 150 | [email protected] www.absoluting.com | Keywords: database information technology microsoft California Delaware SQL DBA - Hybrid - Sacramento, CA [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2203729&uid= |
| [email protected] View All |
| 08:18 PM 25-Feb-25 |