Professional Summary:

• Over 7 Years of SQL Server DBA experience in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2012, 2008, 2008R2, 2005, 2000 in Production 24x7 , Testing, Development, Replication Cluster Server Environments.
• Supports day to day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting.
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Experience in implementing of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Hands on Experience in Writing Debugging Stored Procedures and Triggers, Troubleshooting Database issues.
• Experience in Query Optimization, Re-Indexing, Updating Statistics, tuning Stored Procedures and performing Maintenance Tasks.
• Created maintenance plans to perform index defragmentation, re-indexing and update the index statistics.
• Experience working with DTS Packages, migrating DTS packages.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring full, differential, and log backups.
• Experience in Using Performance Monitor/Profiler to resolve Dead Locks/Long Running Queries and to resolve System Hardware bottlenecks.
• Expert in Database migration from MS SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008, and SQL Server 2008 to SQL Server 2012.
• Experience with Reporting Services SSRS and Analysis Services SSAS.
• Worked extensively in OLTP OLAP environments that included Production 24x7 , QA and database development in SQL Server.
• Good experience with the entire phases of Software Development Life Cycle SDLC
• Very good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies.
• Worked closely with development and Technical Support team to resolve quality issues.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• 24x7 Production Database on Call Support.

TECHNICAL SKILLS:

• Relational Databases: SQL Server 2012/2008/2008R2/2005/2000/7.0, MS-Access 2000/2003/2007, My SQL4/5.
• Operating Systems: Windows NT/ Windows 2000 Advanced Server / Enterprise Server 2003 / Windows XP / Standard, Windows 98, Windows Vista, Windows 7.
• Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS.
• Web Servers: IIS 5.0/6.0/7.0, Apache, Tomcat, Amazon web services, Service Center, Virtual Private Cloud VPC .
• Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.
• ETL: SSIS, SSRS.

PROFESSIONAL EXPERIENCE:

Confidential

MS SQL SERVER DBA

Role Responsibilities:

• Analyzed SQL server over 50 with 200 databases from 2000, 2005, 2008 2008R2.
• Consolidation of SQL server and databases based on physical memory, server memory, I/O waits, linked servers, active servers, offline database.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Monitor connections, locks and performance of SQL server.
• Set up SQL Mail and Created Jobs to Automate Scheduled many tasks.
• Creating new procedures using Dynamic SQL and Table Variables.
• Create and Modify procedures, Triggers and functions.
• Monitoring the databases on a daily basis and checking the Event logs and Error logs.
• Experience in database redundancy strategies, and disaster recovery Data Mirroring, Replication, Log Shipping, and Clustering .
• Setting up logical/physical backups for the databases.
• Responsible for creating tables, triggers, stored procedures, indexes.
• Managing Logins, Users, Roles and User permissions.
• Effectively using DBCC commands, Dynamic Management Views DMV , SQL Profiler, Performance Monitor, SQL Server Management Studio, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.
• Involved in Performance tuning and Query Optimization.
• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV'S and built in performance reports.
• Resolving blocking and deadlock issues using activity monitor and system stored procedures.
• Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers.
• Involved in implementation of replications like Snapshot and Transactional in OLTP environments
• Configured SNAPSHOT Replication using Snapshot agent. Creating Distribution Databases, creating managing Publications, managing Replication monitors
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Experienced in configuring and maintaining transaction and snapshot replication to replicate the data to remote servers
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Analyzed long running slow queries and tune the same to optimize application and system performance.

Confidential

MS SQL SERVER DBA

Role Responsibilities:

• Performed SQL server database upgrades from version 2000 to 2005 and applied patches to 2005 database server instance.
• Maintaining jobs for data massaging from production server to Business Objects server for generating daily reports for financial and marketing team.
• Managed and coordinate with remote user for change request and optimization of application.
• Management and maintenance of data, including backups, data fixes, replication, restoration and high availability of operational systems.
• Configuration and management of security of company SQL servers, including troubleshooting.
• Responsible for planning, executing, and maintaining data integration projects and database upgrades.
• Experience in database redundancy strategies, and disaster recovery Data Mirroring, Replication, Log Shipping, and Clustering .
• Responsible for fine tuning of the database, trouble shooting, user administration, memory management, and running DBCC.
• Involved in Performance tuning and Query Optimization.
• Used multitask data pump in DTS/ETL.
• Responsible for creating tables, triggers, stored procedures, indexes.

Confidential

SQL Server DBA

Role Responsibilities:

• Monitored and maintained over 6 SQL Servers in Production, QA, Test and Development Environments.
• Set up SQL Mail and Created Jobs to Automate Scheduled many tasks.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs.
• Imported Data from Text files and Excel Spread sheet into SQL Server 2000 database using DTS package.
• Creating and maintaining documentation including data dictionary. Installation and maintenance of DBMS software and connectivity to client tool.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs.
• Change management ensuring all changes are tested, communicated, approved, and documented.
• Setting up logical/physical backups for the databases.
• Create packages, procedures, functions, triggers, and handle database performance with tuning.
• Implemented replication model like Merge, Transactional and Snapshot.
• Demonstrating Communication skills and leadership ability. Previous marketing and/or CRM expertise a plus. Demonstrating project management skills.
• Backed up system and user databases related to Merge, Transactional and Snapshot Replication.
• Creating DTS Packages migration of data across different servers and Other Databases such as Oracle and DB2.
• Participating in 24x7 on-call rotation. Good analytical and troubleshooting skills required. Been a good team player with good communication skills and a can do attitude.
• Managing Logins, Users, Roles and User permissions.
• Application installation for database-centric applications like SAP and Siebel.
• Assist Developers in writing and tuning new procedures.
• Creating new procedures using Dynamic SQL and Table Variables.
• Create and Modify procedures, Triggers and functions.

Confidential

SQL Server

Role Responsibilities:

• Installing and configuring default and Named instances of SQL Server 2000, SQL Server 2005, and SQL Server 2008.
• Upgraded and Migrated SQL Server 2000 SP4 / SQL Server 2005 SP2 to SQL Server 2008 using in place and Side-by-Side upgrade methods.
• Creating Database Users, SQL Logins and Server Roles.
• Assigning permissions to Roles and adding users to the appropriate Roles.
• Monitoring Jobs created by Maintenance Plan sub plans.
• Creating and scheduling Full and Differential and Transaction log backup Jobs.
• Creating and scheduling Maintenance related jobs to automate tasks such as Defragmenting Indexes Reorganizing Indexes , Rebuilding Indexes.
• Creating and scheduling jobs to Monitor Changes in the databases.
• Configuring Database Mail and using for setting up notifications in the event of failure of jobs
• Configuring and Implementing Replication techniques such as Database Snapshots, Transactional Replication, and Merge Replication.
• Troubleshooting Replication related problems and errors.
• Configuring and Implementing Log Shipping in Test Database Server environments.
• Configured Automatic Failover for Database Mirroring.
• Use SQL Server Profiler traces to collect and monitor server performance.
• Extensive usage of performance and Monitoring tools such as:
• System Monitor for tracking resource usage
• Activity Monitor in SSMS
• System Stored Procedures

Confidential

SQL Server

Role Responsibilities:

• Installing, Configuring and Administering SQL server 2000 2005.
• Performing Database maintenance activities like Backups, Restoring.
• As a part of the DBA team providing 24x7 production support to the clients.
• Monitoring the Scheduled jobs.
• Configured log-shipping between the servers.
• Monitoring the Disk spaces on all the servers.
• Checking the general Health of the servers for identifying Bottlenecks.
• Analyzing, Identifying and Resolving performance issues of the server.
• Database performance tuning for optimal results.
• Ensuring High Availability using Technologies like DB mirroring, Log shipping.
• Backing and Restoring of Databases
• Scheduling and scripting Jobs.
• Having knowledge in Replication.
• Experience in using Performance Monitor, SQL Profiler.
• Implemented backup and Recovery strategies.
• Maintaining and troubleshooting Log-Shipping.