SUMMARY

• Over 6 years of IT experience in SQL Server Database Administration, Design, System Analysis, Testing, Development and Support of MS SQL Server 2014/2012/2008 in PRODUCTION and DEVELOPMENT Environments.
• Experience in database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services and Database Security.
• Experience working with MS SQL Server 2016, 2014, 2012, 2008 versions. Hands on experience in SQL Server DTS and SSIS (SQL Server Integration Service) package design, constructing, and deployment.
• Extensive knowledge of Relational Database Management Systems (RDBMS)
• Expert in writing TSQL, Stored procedures, Views, Triggers and Functions.
• Expert in Implementing High Availability Solutions such as for Log Shipping, Mirroring and Replication in MS SQL Server Environments.
• Experience in implementing different types of Replication such as Snapshot and Transactional.
• Expert skills in Performance Tuning SQL Servers for Index Fragmentation, Query Plans and Deadlocks.
• Highly proficient in high level design of ETL SSIS and DTS packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server.
• Expertise in database Backup, Recovery and Disaster Recovery procedures. Developed and documented disaster recovery plans and Backup and Recovery strategies for production environment.
• Data modeling experience focusing on high - activity, normalized transaction systems (OLTP), also denormalized databases for datawarehouse and data marts.
• Experience in providing 24 x 7 production support.
• Excellent communication skills, organizing skills, highly punctual and an excellent listener.

TECHNICAL SKILLS

Data Modeling Tools: Microsoft VISIO, ERWIN

Operating systems: Windows Enterprise 10, Windows 8/8.1, Windows 7, Windows Vista, Windows XP Professional, Ubuntu, Cosmos and Unix

SQL Tools: Query analyzer, Enterprise manager, Index tuning Advisor, SQL management studio, Database tuning advisor, Service area configuration, SQL profiler, Client and server utility, SQL server configuration manager, SQL server Business Intelligence development Studio, SSIS, SSRS, and SSAS.

Languages: T-SQL, PL/SQL, VB, HTML, XML, C, C#, .Net

Relational Databases: MS SQL Server 2016/2014/2012/2008 , MS Access.

Reporting Tools: MS SQL Reporting Services (SSRS), MS Excel, Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• As a Production and development support DBA responsible for maintenance of SQL Server instances.
• Installed SQL Server 2014 on Windows servers, applied service packs and security fix for all servers.
• Implemented Database Mirroring on SQL Server 2016/2014 environments.
• Used ERWIN to carry out Logical and Physical data modeling.
• Implemented transactional replication for data refresh.
• Managed all Publisher, Distributor and Subscriber database environments for replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries.
• 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.
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS.
• Scheduled package execution in SSIS.
• Experience on SSIS for data manipulation and data extraction, ETL Load.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created standard documentation for Disaster recovery testing and implemented them.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Created backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests.
• Good knowledge well versed in handling AWS resources like VPC, EC2, EBS, Cloud watch etc.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: Windows Server, MS SQL Server 2016/2014, Erwin & Microsoft Visio.

Confidential

SQL Developer

Responsibilities:

• Created Tables, Indexes, Constraints and Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Actively monitored performances of queries on SQL server using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language.
• Good experience on working with Extract, Transform and Load (ETL) tool.
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2012.
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
• Database and log backups and restoration, backup scheduling the backups. Backing up master and system databases and restoring them.
• Developed SSIS packages to extract and transform data and Involved in Scheduling SSIS Packages.
• Using SQL Server Integration Services (SSIS) to populate data from various data sources using the concept of OLE DB.
• Developed SSIS packages and deployed into Dev, Test and Production Environments.
• Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
• Managing the use of disk space, memory and connections.
• Performed software installation and upgrade, capacity planning.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.
• Eased administrative work through automatic script performing daily/weekly backups.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Performed Debugging in Cosmos through Visual Studio for tracing, breakpoints and logging
• Performed DBCC checks which will helps to maintain physical consistency of the database.

Environment: SQL server 2012, Cosmos, Microsoft Visual Studio 2012/2013.

Confidential

SQL Server DBA

Responsibilities:

• Managed All Production, Development and QA Environments running MS SQL Server 2008/R2.
• Involved in Migration of Production Database Servers from SQL Server 2008 to SQL Server 2008 R2.
• Involved in Performance Tuning on Production, Staging and Test Servers.
• Implemented Database mirroring for High Availability
• Maintained various databases for Production and Testing using SQL Server 2008 R2.
• Worked with SQL Server Profiler and Perfmon.
• Involved in Monitoring Performance of different production servers.
• Planning the location of data, index, and Transaction log files on the disk.
• Performance tuning, and Optimization of Stored Procedures and Queries.
• 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 and Re-indexing.
• Migrated DTS packages to SSIS packages.
• Experience in creating and executing SQL Server Integration Services (SSIS) packages.
• Involved in Migration of Reporting Servers from SQL Server 2008 to SQL Server 2008 R2.
• Managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies and by creating proxy accounts.
• Implemented Data, Transaction and tail log backups & restoration strategies.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Administering 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.

Environment: Microsoft SQL Server 2008/2008 R2, Windows 2008/2003 enterprise server, SQL Profiler Performance Monitor.

Confidential

SQL Server DBA / Developer

Responsibilities:

• Responsible forInstallation, Configurationand AdministrationofSQL Server 2008 on Windows 2008 Servers &Installation of Service Packs & hot fixes.
• Worked with database design team and development team for database design and implementation, used Visio for database design and SQL 2008 for development.
• Documentation of process involved while upgrading SQL server .
• Prepared Documentation for Disaster Recoveryplan and used Log-Shipping for synchronizing databases as part of High Availability.
• Enhanced query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Monitoring SQL Server logs to ensure whether the backup operations,batch commands, scripts have completed successfully.
• Performance tuningand testing stored procedures, indexes and triggers usingDatabase Engine tuning advisor and SQL server profiler.
• Monitoring SQL server performance usingprofilerto find the performance anddead locks.
• Used copy Data Base option to copy relatively small databases between servers in online mode.
• CreatedMaintenance Plansfor Regular Backups and Rebuilding of Indexes.
• CreatingSSISPackages by using advanced tools (i.e.pivot Transformation, Derived Columns, Condition Split, Aggregations) to perform Data Conversion, Consolidation, Cleansing, Scrubbing, loading and data transformation.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 usingSSIS.
• Developed, Deployed and Monitored SSISPackages. ImplementedIncremental Load and Data cleaningby creating Dynamic SSISpackage.
• Documented different Stages of data transformation, procedures and scripts involved in the database.
• 24 X 7 On Call support periodically.

Environment: Database: MS SQL Server 2005/2008, Access, Excel.

Confidential

SQL DBA / System Admin

Responsibilities:

• Performed DBA duties: database backups, restores, performance tuning, and capacity analysis.
• Installed and maintained database applications to improve processing performance including applyingupgrades, patchesandbug fixesin all database instances.
• Performed data consistency andperformance tuningeffectively withSQL Profiler, Index Tuning Wizard.
• Monitoring SQL server performance using profiler to find performance,dead locks, blockings and Capturing long running SQL queriesfor fine-tuning SQL statements that better result in efficient SQL statements processing.
• Relocation of Databasesfrom one server to another server using attach and detach method.
• To analyzelong running slow queriesand tune the same to optimize application and system performance.
• Maintain databaseconsistencywithDBCCat regular intervals Monitor and alert users with the field status changes.
• Timely completion of activities for database backup, restoration as a Disaster Recovery Solution and health check of databases.
• Improved performance of database by analyzing indexes, its fill factor and fragmentation issues.
• Created and Scheduled Jobs for proper and timely execution and sending Alerts Using SQL Mail.
• DevelopedSQL scripts to Insert, Update and Deletedata in SQL database tables.
• Created efficientStored Procedureand functions which implement necessary business logic to support the front end application.
• Involved in themigrationof MS Access databases to SQL Server 2008.
• Database design and development, T-SQL Stored Procedures, Triggers and Functions.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams, Table Structure
• Responsible for the creation and optimization ofDTSpackages for importing, exporting, and scrubbing data from heterogeneous sources and for eliminating data duplication.
• Created and maintained Users/ Logins.
• Maintained and created replications (Transactional and Snapshot).
• Generated Script files of the databases whenever changes were made tostored procedures or views.
• Created DTS packages to migrate data from various sources to the SQL Server 2008.
• Solving Tickets on Daily Basis for Production Issues.