SQL Server DBA

Description

Installing, Configuring, Monitoring, Maintaining SQL Server 2000 / 2005 / 2018 Databases.Strong Understanding of Conceptual, Logical and Physical Data Models and ability to transform Logical Data Model to Physical Data Model.Performing Database Capacity Planning (CPU / Memory / Disk Usage Estimations).Analyze and Optimize Performance for Retrieving and Storing Large Amounts of Datasets from Heterogeneous Data sources like IBM DB2, Teradata etc.Experience in implementing Database High Availability Technologies like Clustering, Replication, Log shipping and Database Mirroring.Expert in using Third party tools like Idera's SQL Safe backup, Quest's Litespeed and IBM's Tivoli Storage Manager for Database Backup / Restore Operations.Ability to Create / Schedule Database Maintenance Plans like Checking Database Integrity, Reorganizing / Rebuilding Indexes, Updating Statistics, Cleaning up Job History, Truncating Transaction Logs etc.Familiarity with Various Performance counters (both System and SQL Server related) using Windows Perfmon tool and ability to correlate this data with SQL Server Profiler, SQL Server 2005 Dynamic Management Views and Functions.Expertise in Designing SQL Server Security Models (Windows / Mixed Mode Authentications) and implementing Security Best Practices in Production Database Servers.Implement Best Practices in Configuring SQL Server I/O subsystem for optimal Running in SAN Environments.Development Skills Expert in transforming complex business logic in to Database Model with Entity Relationships, Data Integrity Considerations.Familiar with at least One Data Model tools like ERWin, Visio or Power Designer etc.Excellent Programming skills with Transact SQL.Experience in working with all types of Database Objects like Tables, Views, Indexes, DDL /DML Triggers, Stored Procedures, Userdefined Functions, UserDefined Data types etc.Strong Experience in Extracting, Transforming and Loading Data Operations using Tools like BCP, DTS and SSIS etc.Experience in Designing OLAP Cubes using SQL Server Analysis Services and Expert in writing MDX Queries.Expert in Designing Reports using SQL Server Reporting Services.