SUMMARY

• Senior MS SQL Server DBA with Extensive knowledge in Managing SQL Server environment
• Eight Years of IT experience with Database Administration on MS SQL SERVER 2012/2008R2/2008/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.
• Maintained databases with sizes ranging from Large to Very Large Databases (terabytes).
• Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company’s Security Policies
• Worded on VMware and Virtual Environment.
• Extensive knowledge with Backups, Restoration and Disaster Recovery Planning.
• Extensive experience in developing Stored Procedures, Views, Triggers, and Complex Queries on SQL Server 2012/2008 R2/2008/2005/2000/7.0.
• Experience in Upgrading of SQL Server from version 2000 to 2005 and 2005 to 2008/2008R2/2012.
• Highly Proficient in migration of Databases, packages and Job activities from MS SQL Server 2000 to MS SQL Server 2005/2008R2/2012 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).
• Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications
• Good experience with SQL Server 2005 Online Database Indexing and Recovery.
• 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.
• Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
• Have knowledge in ADABAS database management system.
• Performed Server 2008 R2, 2003 and IIS Systems Administration, and configuration
• 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.

TECHNICAL SKILLS

Operating Systems: Windows 2012/2008 R2/2003, Windows 7/8 Professional

RDBMS: SQL Server 2012/2008 R2/2008/2005/2000, MS Access

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, Business Intelligence Development Studio, SSIS

Web Technologies: XML, HTML, JAVA Script

Languages: T-SQL, C, JAVA

Reporting Tools: SQL Server Reporting Services, Crystal Reports

Applications: Microsoft Office, Erwin, MS VISIO 2003/2005.Networking TCP/IP, Named Pipes, VIA

Other Tools: Lite Speed, Erwin, Test Director, Varalogix-Q, Idera Diagnostic Manager, Foglight

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior MS SQL Server DBA

Responsibilities:

• Managed 100+ Production SQL Servers in Virtual and Physical Environments.
• Installed, configured and migrated SQL Server 2012, 2008 R2 and SQL Server 2005 on windows 2008 and 2003 servers, applied service packs and security fix for all servers.
• Involved in development activities including hardware installation and configuration, and participation in database design, architecture and SQL scripting.
• Participated in setting up DR and HA with SQL Server CLUSTERING, MIRRORING and LOG SHIPPING
• Implemented Database Mirroring on SQL Server 2008 environments.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Implemented transactional replication for data refresh
• Managed all Publisher, Distributor and Subscriber database environments for the replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Supported SQL Server environment in OLTP and DSS systems
• Installed SQL Server Active/Active and Active/Passive Clusters in 2012,2008 R2
• Upgraded SQL Server 2005/2000 to SQL Server 2012/2008R2
• Managed multiple SQL Server instances in Active/Active and Active/Passive clusters
• Installed and configured Async and Sync Mirroring for Production and DR environments
• Setup Log Shipping for production databases to carry out DR and failover
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Created solid stored procedures for Backup and Recovery process
• Used extensive SQL Server DMV's for Performance and System Monitoring
• Used DMV’s for finding Index Fragmentation and Worst performing Queries
• Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server.
• Creating, Scheduling and deploying extensive SSIS packages from Development to Production.
• Used Various different Transformation in SSIS for ETL packages
• Created extensive reports using SSRS ( Tabular, Matrix )
• Performance tuning, and optimization of procedures and queries.
• Worked a lot on creating, designing databases and creating Views, Stored Procs and Triggers
• Worked hand in Hand with developers to carry out builds and releases.
• Used Various third Party tools for monitoring SQL Servers and Backing up Databases

Environment: Windows 2012/2008 R2/2003/2000 Server, MS SQL Server 2012,2008 R2/2005, Business Intelligence Development Studio, T-SQL, SSMA, IDera SQL Safe backup, IDera Diagnostic Manger and other IDera tools, DTS, SSIS, SSRS, Performance Monitor, SQL Profiler

Confidential, Round Rock, TX

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.
• Suggested design and architecture structure for Databases and servers.
• Implemented SQL Server 2012/2008R2 Active/Active cluster setup on Windows 2008 R2 servers.
• Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.
• Configured and Monitored MS SQL Server 2008R2 in Log Shipping from primary server to DR server (different geographical location) and also carried out role changes and role reversals.
• Installed and configured SQL Server 2008R2 and 2005 with Service Packs as per the Business Requirements in UAT, Development & Production environments
• Creating, Monitoring and Troubleshooting 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 based on the database environment. Used Idera SQL Safe backup tool to backup databases.
• Used Performance Monitor and SQL Server Profiler (ran Trace) to optimize long running queries and thereby improved the performance of the queries.
• Worked with different teams (Application, Active directory, Engineering & QA) to deploy projects to UAT (Testing), Development, and Production environments.
• Migrating SQL Server 2000/2005 databases to SQL Server 2008 R2.
• Used SQL Server Upgrade Advisor to analyze SQL server 2005 in the process of migration.
• Proactively worked with developers/project team for achievement of efficient database access and resource usage for applications. This includes activities like designing indexes, adding or eliminating columns on existing indexes, and maintaining indexes/re-organizing tables, recommending SQL configuration changes.
• Created packages successfully using SSIS to transfer large volume of Data.
• Routine tasks but not limited to: Monitoring and Maintaining the security, integrity and availability of Servers, performance tuning, building packages, responding to users and developer issues and monitoring database backups.

Environment: Windows 2008 R2/2003/2000 Server, MS SQL Server 2008R2/2008/2005/2000/7.0, Business Intelligence Development Studio, T-SQL, SSMA, IDera SQL Safe backup, IDera Diagnostic Manger and other IDera tools, DTS, SSIS, SSRS, Performance Monitor, SQL Profiler

Confidential, Jersey City, NJ

SQL Server DBA

Responsibilities:

• Installed Standalone and Clustered SQL Server 2005/2008 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.
• 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 R2/2003 Server, MS SQL Server 2008 R2/2005/2000, Business Intelligence Development Studio, T-SQL, SSMA, Lite Speed, DTS, SSIS, SSRS, BCP, SQL Profiler

Confidential, Pittsburgh, PA

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 resolving major performance issues for databases
• Researching on database/index fragmentation and running rebuild indexes and update statistics
• Using latest sql server DMV’s for finding performance bottlenecks
• Running Index tuning wizard and rebuilding indexes for faster query response.
• 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).
• 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, Secaucus, NJ

SQL Server DBA

Responsibilities:

• Installation of SQL server 2005/2008 on Production and Virtual environments.
• Implemented transactional and snapshot 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 2008/2005/2000, SSIS, SSRS, IDEARA Diagnostic, SQL Compare

Confidential

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/2008 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/2008 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 2008/2005/2000, SSIS, SSRS, SAN, DTS