| : SQL DBA :: CALIFORNIA,SACRAMENTO (Hybrid) Must be local (Rate 45) at Sacramento, California, USA |
| Email: arfin@absoluting.com |
|
https://jobs.nvoids.com/job_details.jsp?id=2204889&uid= From: MD Arfin, Absolute IT arfin@absoluting.com Reply to: arfin@absoluting.com Position: SQL DBA Duration: 06 Months Location: CALIFORNIA,SACRAMENTO (Hybrid) Visa: GC, GC-EAD, H4/EAD, USC JOB Description 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. Keywords: database information technology green card microsoft Delaware Maryland : SQL DBA :: CALIFORNIA,SACRAMENTO (Hybrid) Must be local (Rate 45) arfin@absoluting.com https://jobs.nvoids.com/job_details.jsp?id=2204889&uid= |
| arfin@absoluting.com View All |
| 10:37 PM 25-Feb-25 |