What are the responsibilities and job description for the SQL Database Administrator/Developer position at Kaygen?
KAYGEN is an emerging leader in providing top talent for technology based staffing services. We specialize in providing high-volume contingent staffing, direct hire staffing and project based solutions to companies worldwide ranging from startups to Fortune 500 and Managed Service Providers (MSP) across a wide variety of industries.
ROLE : SQL Database Administrator / SQL Developer
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.
- dvanced T-SQL, PowerShell 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
Required Skills : Microsoft SQL Server (MS SQL Server);Database Administration; Database Design; Database development; SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS)
At KAYGEN, we are always looking for dynamic, talented and experienced individuals. We invite you to join our team of talented IT professionals, consulting at client locations across the globe. Our culture is team-orientated; we strive to stand by our core values of respect, honesty and integrity. Our team of experienced staffing experts will work with you to find you the best opportunity. For more information please visit us at www.kaygen.com.
Benefits :
Achieve your Kaizen by clicking here. A unique and exclusive talent community supported by Kaygen, that includes programs like : Certifications
