Technical Lead SQL Server DBA
DSI, LLC
Philadelphia, United States of America
yesterday
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Senior Compensation
$ 160KJob location
Philadelphia, United States of America
Tech stack
API
Cloudera Impala
Cluster Analysis
Databases
Database Servers
Disaster Recovery
Hadoop
Hadoop Distributed File System
Hive
Local Security Policy
Microsoft SQL Server
Performance Tuning
Query Optimization
Cloudera
SQL Server Reporting Services
SQL Server Integration Services
Sqoop
SQL Server Analysis Services
Alwayson
Enterprise Software Applications
System Availability
Apache Flume
Guidewire
Legacy Systems
Job description
- Installations, configuration and security settings for SQL Server 2005, 2008 and 2008R2 ,2012 stand-alone servers.
- Upgrading/Migration the databases to SQL Server 2005 to 2008/2008R2/2012
- Experience of Clustering, Replication, Logshipping & Mirroring. Experience with backups, restores and recovery models. Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO).
- Knowledge on SSRS, SSAS, SSIS configurations.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Responsible for planning and organizing database, Database creation, performance tuning, restoration, patch installation etc
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Refine and automate regular processes, track issues, and document changes. Assist developers with complex query tuning and schema refinement.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
- Experience in AlwaysOn.
- Creation and maintenance of database in cloud.
- MSSQL certification.
- Knowledge on ITIL process.
- Good Communication skill.
- Good team coordination (Onsite / Offshore) - 24 x 7 support experience.
- Good to have Experience in other DB technologies.
- Preferred to have Guidewire, The Senior Software Developer plays a critical role in the design, development, and maintenance of enterprise applications, supporting both new development and legacy systems. This…
- 1 month ago
Requirements
Requirements: 4+ years working with and coding in Apache Hadoop, preferably with Cloudera's distribution Hadoop ecosystem (Hive, Impala, Flume, Sqoop, Hadoop APi, HDFS) Basic Ha…
- 1 day ago
Benefits & conditions
- $120,000 per year