SUMMARY

• 8 years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2014 and SQL Server 2012/2008/ 2005/ 2000.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Worked on SQL Server 2012 migration from SQL Server 2008 and 2005
• Extensively worked on Data and Backup compression in SQL Server 2012.
• Worked with SQL Server 2012 new MERGE statement
• Good Knowledge at SQL Server 2012 new features like Policy Based Management, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)
• Knowledge on SQL Server Management studio 2012 new and enhanced features like object search, Object Explorer Details, activity monitor, Multi Server Query and T - SQL Debugger
• Implemented the new SQL Server 2008 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, ETL, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection.
• Worked on 32 bit and 64 bit SQL Server and MSCS Configurations.
• Administering SQL Server High Availability.
• Data modeling Experience like Physical data modeling and logical by using ERWIN.
• SQL Server Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages and SSAS with OLAP.
• Worked on Replication and Log shipping for SQL Server High Availability
• Worked on MongoDB,MongoDB is document database that povides high performance,high availability and high scalability
• Extensively worked on Active-Active and Active-Passive Clustering
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Experience with 2012 Always On High Availability groups.
• Having hands-on experience in Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Hands on experience working with MongoDB (Installed and configured) on Linux servers.
• Extensively implemented the change management processes by using Team foundation server (TFS), Visual source safe (VSS) and Clear case.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Used Filtered Indexes for improving query performance, lower storage and maintenance cost.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
• Done Password Changes on cluster and Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management.
• Experience with business requirements analysis, entity relationship planning and reporting structures.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Created Linked Servers between SQL Server 2005 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Databases: MS SQL server 2014/2012/2008 R 2/2008/2005/2000 , MongoDB

ETL Tools: SQL Server Integration Services (SSIS), INFORMATICA, SQL Server DTS

Other Tools: Microsoft Visual Source Safe, IDERA, Red gate, Fog light, Sentry

Data Modeling Tools: Erwin, Microsoft Visio 2007

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, DTS, BCP, SQL server profiler, Event Viewer, and Index Tuning Wizard, SQL Server Agent, SSRS Log Shipping, T-SQL, DDL, SQLCMD, BIDS, Triggers

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Sr. SQL Server DBA

Responsibilities:

• Managed Production, Development, QA and UAT environments
• Worked extensively on Virtual and VMware Environments.
• Worked on ACTIVE/ACTIVE and ACTIVE/PASSIVE clusters
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Managed Production environment for High Availability in Active/Active and Active/Passive mode
• Worked on setting up and managing Snapshot and Transactional Replication
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring and Log shipping for disaster recovery.
• Maintained various databases for Production and Testing using SQL Server 2014/2012 R2.
• Planning the location of data, index and Transaction log files on the disk.
• Performance tuning and optimization of procedures and queries. extensive use of SQL Server DMV's for Performance Tuning
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks
• Implemented High Availability with AlwaysOn Availability Groups.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.
• Migrated MS SQL Server 2008 to MS SQL Server 2012
• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa
• Installed and configured MongoDB on Linux servers.
• Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2012.
• Automated mongoDB backups using mongodump utility.
• MongoDB supports search by field, range queries, regular expression searches.
• Documented all the steps and procedures for future s.
• Interacted with concern application team in fixing the problems when ever needed.
• Created performance baseline reports using RML tool and documented for future use.
• Involved in setting up database mirroring for production server
• Configured replication methods like snapshot, transactional and merge replications.
• Monitoring and scheduled jobs on production and staging environment.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Resolving performance related issues to Blocking, Deadlocks and long running queries
• Provided 24 x 7 Production support for the database and application issues.

Environment: SQL Server 2014/2012/2008 R2, VMware, Virtualization, SSAS, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, TFS, Crystal Reports, MongoDB, Windows 2008 R2/2003/2000, ERWIN, Lite Speed Backup

Confidential, PA

SQL Server DBA

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship(ER) diagrams.
• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2005.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Managed the migration of SQL Server 2005 databases to SQL Server 2008.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in implementation and maintenance of disaster recovery solutions such as replication and log shipping.
• Using MongoDB high availability of database will be maintained.
• Indexes are designed using MongoDB or Mysql or Oracle.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Prepared the project management and technical documentation.
• Implemented AlwaysOn functionality on a Clustered environment
• Implemented AlwaysOn with Sync and Async configuration.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Solving the Bugs Reflected by the Testing team.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Configured transactional and snapshot replication and managed publications, articles.
• Rebuilding the indexes at regular intervals for better performance.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings for better server management.
• Monitoring the servers using Idera third party software.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2012/2008, Oracle 11g/10g, .Net Framework 3.5/4.0, C#.Net, Asp.Net2.0, JavaScript, SSIS, SSRS, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access, SPSS, Erwin, Visio Professional, TFS

Confidential, Jersey City, NJ

SQL Server DBA with SSIS Data Warehouse

Responsibilities:

• Responsible for Query optimization and Performance tuning.
• Rebuilding of indexes to improve data retrieval performance
• Managed Microsoft Clustered SQL Server 2005 and 2008 environments.
• Involved in Migration from SQL 2005 to SQL 2008
• Managing server logins, database users and permissions.
• Created Clustered Indices and Non-Clustered Indices to increase the performance of database.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Used the SQL server integration services (SSIS) as a part top transfer logins from SQL server and to move data from one server to another server.
• Configuration and Administration of IIS 6.0, Windows 2003 server.
• Created the Database Objects like Tables, Views, Functions, Stored Procedures and Triggers.
• Managing security tasks like granting and revoking permissions

Environment: Windows Server 2000/2003, VMware, SQL Server 2008/2005, DTS, T-SQL, SSRS, SSIS, SQL lite speed, Erwin, Visio Professional, TFS

Confidential, Baltimore, MD

SQL Server DBA

Responsibilities:

• Database Administrator, Database Programming.
• Responsible for Logical & Physical Database Design.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Creation of New NT Logins and granting privileges to users/Groups and objects.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes.
• Backup and recovery of Master, MSDB and Application databases.
• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current.
• Implemented log shipping and performed changing roles when production data base goes down.
• Worked extensively on DTS Package designs for Import/Export from various Data Source Flat file, Excel, MS Access to MS SQL Server and schedule the jobs in SQL Server.
• Provide 24x7 dedicated support to all Production, QA & Development MS SQL Server Environments.
• Related issues /performance related issues with Minimal Downtime & Maximum Reliability.
• Responsible for deployment from development to test, UAT and production environments.
• Review / test / apply all database changes to all environments including QA, Development and Production Servers. Monitor SQL Error Logs /Schedule.

Environment: MSSQLServer 2008/2005,.NET Framework,DTS, SSIS,SSRS,SVN,C# .NET, SSL, IIS 6.0/7.0,Windows 2008/2003, Erwin, Excel

Confidential

Sr SQL DBA

Responsibilities:

• Database Administrator, Database Programming.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• To set up SQL Server configuration settings.
• Backups and Restoration of data/database using a Third Party Tool (SQL Lite Speed).
• Recovering the databases from backup in disasters
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Involved in trouble shooting and fine-tuning of databases for its performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Managing the San backups.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Worked with different upstream team for downloading ETL MART data.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, Windows 2003/2000 Server, SQL Lite Speed 4.5, Visio, Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential

SQL Server DBA

Responsibilities:

• Database Administration for Development, Test and Production servers with MS SQL Server 2000/2005 on Windows 2000/2003NT 4.0.
• Created backups for databases.
• Involved in Performance tuning.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system with ERWIN.
• Gathered requirements from business users.
• Wrote user requirement documents based on functional specification.
• Designed physical data models.
• Created functions, views and triggers.
• Developed source to target specifications.
• Created DTS package and schedule the jobs for batch processing.
• Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.

Environment: Windows Server 2003, MS SQL Server 2000/2005, Erwin, DTS, Stored Procedure, Views, Triggers.