Previous Job
SQL Server Database Administrator (81476
Ref No.: 17-15723
Location: Valley Cottage, New York
Position Type:Contract
Start Date: 04/24/2017
Position: SQL Server Database Administrator (81476)
Client: Capgemini
Location: Valley Cottage NY
Duration: 12 months
Job Description/Required Skills:
· Installation and configuration of SQL Servers and SQL instances and databases.
· Installation and configuration of SQL Report Server and SQL Server Integration Services
· Co-ordination with interfacing team & Project team
· Ensuring CheckAlt security policies to control access and authentication
· Monitoring of Server and Databases health and performance, to ensure high levels of performance, availability, and security.
· Provide technical support for the database environment including overseeing the development and organization of the databases.
· Analyze and provide the storage requirements for SQL environment.
· Database Backup and Restore.
· Requirement gathering and project specifications in coordination with project teams and translate the business requirements to technical requirements for SQL
Server build
· Preparing POC for server build and implementation
· Additional SQL Server components deployment and configuration subject to the project / application requirements
· Upgrades & applying Hot fixes/Service Packs & Replication
· Vendor coordination-Resolution of issues where OEM intervention is necessary (bug fixes, patches)
· Advanced configurations cluster, mirroring, replication and log shipping setup
· Database hardening – Security compliance, DR setup and testing
· Performance monitoring and capacity planning
· Co-ordination with interfacing team & Project team.