We provide IT Staff Augmentation Services!

Senior Ms Sql Server Dba Resume Profile

NY

Summary:

  • Over 8 years of IT experience with Database Administration on MS SQL SERVER 2012/2008 R2/2005/2000/7.0 in Production, Development and Testing Environments.
  • Hands-on experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server 2012/2008 R2/2008/2005/2000/7.0 on Windows 2008/2003/2000/NT server.
  • Implemented MS SQL Server 2012 on Development and Test Environment
  • 3 Years experience with Oracle 10g and using RMAN
  • Oracle Certified professional in Oracle 10G
  • 5 years solid experience on SQL Server Integration Services SSIS created solid ETL packages
  • 3 years of experience in creating heavy duty SQL Server Reports with SSRS
  • Maintained databases with sizes ranging from Large to Very Large Databases terabytes .
  • Strong experience with T-SQL, Stored Procedures, Functions and Excel macros
  • Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company's Security Policies
  • Extensive knowledge with Backups, Restoration and Disaster Recovery Planning.
  • Extensive experience in developing Stored Procedures, Views, Triggers, and Complex Queries on SQL Server 2008 R2/2008/2005/2000/7.0.
  • Experience in Upgrading of SQL Server from version 2000 to 2005 and 2005 to 2008/2008R2.
  • Highly Proficient in migration of Databases, packages and Job activities from MS SQL Server 2000 to MS SQL Server 2005/2008R2 and also migrating the database from development to production, and migrate the data between the databases.
  • Excellent knowledge of Database concepts such as Entity-Relationship Modeling, Transactional Management, Normalization, Indexes etc.
  • Extensive experience in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster.
  • Experience in Constructing Server Baselines and Performance Tuning using tools like Windows System Monitor, SQL Profiler, DMV's, and SQL Query Analyzer and performed Query Optimization.
  • Hands-on experience with SSIS SQL server Integrated Services , SSRS SQL server Reporting Services .
  • Experience in designing implementing high availability, clustering, log shipping and/or mirroring standby, large database management, and partitioning.
  • Experienced in Data Migration between Homogeneous Heterogeneous Systems using various tools SQL Server Upgrade Advisor, DTS Package Migration Wizard, Import Export Data, DTS Packages, Bulk Insert, BCP and SSIS .
  • Automated Database Consistency Checks, Fragmentation checks and Index Reorganization/Rebuilding Operations.
  • Hands on experience in creating database maintenance plans monitored the jobs by generating alerts to be sent to the operators via email Pager notifications using SQL Server Agent.
  • Recommended automated testing tools and continuous Build integration procedures.
  • Eliminated DB access bottleneck to significantly improve response time to client queries.
  • Results-driven software professional with a demonstrated ability to successfully architect and implement complex large-scale, N-tier, distributed, real-time Database Environment.
  • Outstanding track record of driving the project to success through various phases of Software Development Life Cycle. Deep desire to solve problems with persistence and pays meticulous attention to details.

TECHNICAL SKILLS:

Windows Server 2008 R2, Windows Server 2003, MS SQL Server 2012/2008 R2/2008/2005/2000, Enterprise Manager, Query Analyzer, Oracle 10g/11i, DTS, MS SQL SSRS, SSAS, SSIS, SQL Profiler, DB2,AIX,ASP.Net 2.0, SQL, PL/SQL, Visual Studio 2008/2005, T-SQL, ERWIN, Database Modeling, Microsoft VISIO, IDERA SQL Diagnostic Manager, SQL Litespeed, IDERA, Lumigent Log Explorer, Dell PowerEdge, HP Blade, VMware.

PROFESSIONAL Experience

Confidential

Senior MS SQL Server DBA

Responsibilities:

  • Extensively worked in OLTP OLAP environments that include Production, UAT and Development databases in SQL Server.
  • Provided 24/7 production support on a rotating roster schedule.
  • Worked extensively on VMware and Virtual instances of MS SQL Server
  • Worked extensively with writing T-SQL, Stored Procedure, Functions, Views, Triggers and Excel Macros
  • Implemented SQL Server 2008R2 Active/Active cluster setup on Windows 2008 R2 servers.
  • Administered Oracle Database Instances and used RMAN for Backup/Recovery
  • Implemented SQL Server 2012 on Development and QA Environment
  • Good exposure on Cluster environment servers, to failover/failback Automatic/Forced to the cluster nodes.
  • Configured and Monitored MS SQL Server 2008 R2 in Log Shipping for Disaster Recovery.
  • Installed and configured SQL Server 2008R2 with Service Packs in UAT, Development Production environments
  • Worked with SAN Technology and SAN boxes.
  • Created Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.
  • Designed and implemented high level backups/restore strategies for point in time recovery purposes.
  • Used Idera SQL Safe backup tool to backup databases.
  • Used Performance Monitor and SQL Server Profiler to optimize long running queries and improved the performance of the queries.
  • Worked with different teams to deploy projects to UAT Testing , Development, and Production environments.
  • Migrating SQL Server 2000/2005 7.0 databases to SQL Server 2005 and then to 2008R2.
  • Used SQL Server Upgrade Advisor to analyze SQL server 7.0 in the process of migration.
  • Converted DTS Packages to SSIS Packages using DTS Package Migration Wizard
  • Created solid ETL packages with SSIS using various transformations, sources and destinations
  • Created packages in SSIS with solid error handling, logging and error re-direction
  • Used VB Scripting in SSIS transformations
  • Deployed SSIS packages from one server to another and scheduled the packages for automation
  • Created heavy duty reports with SSRS, parameterized and drill down reports
  • Configured SSRS report server
  • Created packages successfully using SSIS to transfer large volume of Data.
  • Monitoring SQL Server Instances with IDERA diagnostic Manager

Environment: Windows 2008 R2/2003/2000 Server,Oracle 10G, VMWare, Excel, SAN, MS SQL Server 2012/2008 R2/2005/2000/7.0, Business Intelligence Development Studio , DTS, T-SQL, SSMA, IDera SQL Safe backup, IDera Diagnostic Manager and other IDera tools, DTS, SSIS, SSRS,VB Script Performance Monitor, SQL Profiler.

Confidential

Senior MS SQL Server DBA

Responsibilities:

  • Installed Standalone and Clustered SQL Server 2005/2008 R2 instances in Production, Development, Test, Staging environments.
  • Experience in setting up High Availability environments like Active-Active and Active-Passive Clustering.
  • Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
  • Worked extensively on Database space management, performance monitoring and alert management.
  • Configuring, administration and troubleshooting multiple databases which include databases in QA and Production environments in clustered and stand-alone environments.
  • Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements
  • Suggested backup strategies, Scheduled backups and Performed restoration operations.
  • Worked with migrating data from SQL Server 2000 and 2005 to SQL Server 2008.
  • Created Jobs and scheduled jobs according to the requirements.
  • Created linked server between SQL servers.
  • Designed and created ETL process and design in SSIS
  • Implemented various transformations and created SSIS packages
  • Created SSRS simple and Drill-down reports depending on client requirement
  • Dropped and recreated the indexes on tables for performance improvements.
  • Written complex stored procedures and functions and integrated it with the front end application.
  • Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.
  • Data transfers between various servers using BCP and DTS.
  • Extensively used SSIS to move data from text files to SQL Server.
  • Created packages successfully using SSIS to transfer large volume of Data.

Environment: Windows 2008/2003 Server, MS SQL Server 2008/2005/2000, Business Intelligence Development Studio , T-SQL, SSMA, Lite Speed, DTS, SSIS, SSRS, BCP, SQL Profiler.

Confidential

Senior MS SQL Server DBA

Responsibilities:

  • Provided 24/7 on call production support.
  • Installed SQL server 2008 and Migrated SQL Server 2005 databases to SQL server 2008 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a test environment to be the future production environment.
  • Worked on installing, configuring and maintaining of SQL Server 2000 and 2005 on Windows server 2003.
  • Configured the Log shipping and scheduled jobs to setup log shipping between production servers.
  • Implemented and tested the point in time recovery of the production databases.
  • Implemented Transactional Replication between Primary Server and Sub Systems.
  • Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
  • Created Users and Roles, and managed security and permission of different SQL Server objects.
  • Exported and imported data from text files and Excel to SQL Server using bulk copy insert and BCP utility.
  • Running DBCC consistency check, and fixing data corruption in user databases.
  • Experience in Tuning Databases using Performance Dashboard.
  • Developed several reports using SQL server Reporting services SSRS .
  • Running Index tuning wizard and rebuilding indexes for faster query response.
  • Maintained stand by servers using log shipping and replication concepts.
  • Prepared the coding guideline documents for SQL server developers.
  • Extensively used SSIS to move data from text files to SQL Server.
  • Coordinating with the development team regarding tuning the SQL queries and stored procedures.

Environment: Windows Server 2003, Microsoft SQL Server 2008/2005/2000, T-SQL, Business Intelligence Development Studio, Database engine tuning Advisor, SSIS, SSRS, BCP, SQL Profiler.

Confidential

MS SQL Server DBA

Responsibilities:

  • Installation of SQL server 2005 on development and testing environments.
  • Implemented the peer-to-peer replication in development environment.
  • Used dynamic management views DMV's to monitor the health of a server instance, diagnose problems, and tune performance.
  • Interacting with Business Analysts Developers in identifying the business requirements, designing and implementing the database schema.
  • Installation of SQL servers on Development, Stage and Production Servers.
  • Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting privileges to users and groups.
  • Provided 24/7 on call production support during off hours/ weekends/ holidays.
  • Experience in using Crystal Reports for designing reports.
  • Created batch files for executing the SQL server database objects.
  • Imported data from text files and excel spread sheets into SQL Server 2000 databases using DTS packages.
  • Writing new stored procedures and modifying existing ones and tune them such they perform well.
  • Implemented auditing using triggers and enforcing business rules via checks and constraints.
  • Automated processes using SQL Server jobs.
  • Proper use of views to prevent unauthorized access.

Environment: Win 2003 Server, MS SQL Server 2005/2000, Visual Basic 6.0, JavaScript, HTML and Crystal Reports.

Confidential

Junior SQL Server DBA

Responsibilities:

  • Involved in development activities including hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.
  • Responsible for configuration, Tuning of MS SQL Server 2005 and provided 24 X 7 dedicated support to all production and development servers.
  • Involved with Installation, Upgrade Troubleshooting of MS SQL Server 2000 to MS SQL Server 2005 Databases and Servers.
  • Responsible for migration of databases from one version to other versions and applying patches.
  • Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures
  • Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
  • Actively involved in Normalization 3NF De-normalization of database.
  • Scheduled Jobs and Alerts using SQL Server Agent.
  • Configured Transactional replication between Primary Server and three Read Only servers, with separate Distributor server and experience in replication problems.
  • Used DDM Data Dependency Mechanism to balance the load of data across multiple servers.
  • Involved in capacity planning in estimating troubleshooting and sizing of tables.
  • Developed complex Stored Procedures.
  • Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Environment: Windows Server 2003, SQL Server 2005/2000, SQL Server Analysis Services, VB, SAN, DTS, SSIS

Hire Now