Occupation:Database Administrator |
Location:Brooklyn, NY |
Education Level:Bachelor |
Will Relocate:YES |
Description
Professional Summary * Over 7 years of experience in Database Administration for very large and complex databases in SQL Server 2000, 2005, 2008, 2008R2, 2012 and 2014. * Experience with installation of Microsoft SQL Server in Production, Development and Testing in Clustered and Stand-alone Server Environments on both 32-bit and 64-bit systems. * Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. * Expertise in MS SQL Stored Procedures, Cursors, Views, Triggers and Indexes * Extensive experience in MS SQL Server Installation, Configuration and upgradation, Performance Tuning, Query Optimization. * Experienced on Extraction, Transformation and Loading (ETL) process using SSIS, DTS and other application tools. * Experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages. * Expertise in planning and implementing MS SQL Server security, database permissions, Backup/Recovery, Client/Server Connectivity and running Database Consistency Checks. * Experience in trouble shooting database issues and performing consistency checks using DBCC commands, Dynamic Management Views, Dynamic Management Functions. * Experience in developing SQL and Windows scripts * Good knowledge in Normalization and building Referential Integrity. * Hands on experience in using Performance tools like SQL Profiler, Index Tuning Wizard & Database Engine Tuning Advisor to troubleshoot and monitor SQL Server. * Good experience in performance testing the databases. * Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users. * Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) DTS/SSIS packages. * Experience in working on different OLAP environments. * Expertise in T-SQL writing stored procedures, triggers and functions. * Administering SQL Server High Availability and Disaster Recovery strategies. * Experience in Disaster Recovery Planning and Security Management operations. * Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning. * Having hands on experience in DR processes including Log shipping and Database Mirroring. * Worked on SQL Server migrations. * Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. * Management of Database Space, Growth Monitoring of Data & Transaction log files.
Accomplishments
Highlights:
Keywords
