SUMMARY:

• 8 + years of experience in database administration activities like Installation, Configuration, Database design, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services and Database Security.
• Experienced in creating Maintenance plans and backing up databases, restoring databases. Creating jobs experienced in rebuilding master database and restoring Master database and user databases.
• Developed and documented disaster recovery plans, backups and recovery stagey for production environment.
• Develop ETL procedures using DTS/SSIS tool and ability to analyze complex data from multiple heterogeneous sources.
• Worked in production environment providing Production Support, Production database server implementation, Database Migration.
• Experienced in use of different Transformations in SSIS packages like Audit, Multicast, Conditional split, Aggregation, Pivot, Union, Merge, Data Conversion, and Derived Column etc.
• Experience in planning and implementing clustering, mirroring and replication of SQL server database for high availability.
• Provide capacity planning analysis for database resource requirements. Support and trouble - shoot jobs and other system control processes.
• Expertise in using SQL Server Profiler, Database Tuning Advisor and Perfmon.
• Proficient in implementing business crucial logic and implementing them in backend, using efficient stored procedures and functions.
• Good working knowledge of Data warehousing concepts and OLTP
• Experience in data extraction, transforming and loading (ETL) using SQL Server Integration Services.
• Implementing Log Shipping Technique used for hot backup solution and migration.
• Experienced in performing inplace upgrade, side by side migration and migration to new hard ware.
• Excellent knowledge in creating Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Expertise in planning and implementing SQL Server Security and database permissions.
• Scheduled and monitored all maintenance activities including database consistency check and index de-fragmentation.
• Experience in creating USERS and GROUPS in Active Directory.
• Excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hard working and high level of motivation. A quick learner with an aptitude for taking responsibilities.

TECHNICAL SKILLS

ETL Tools: SSIS (SQL Server Integration Services)

Reporting Tools: SSRS (SQL Server Reporting Services), Business Objects XI

Databases: SQL Server 2000/2005/2008/2012/2014

Programming Languages: SQL, TSQL, C, ASP

Data Modeling Concepts: Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension Tables

Tools: & Applications: SQL Server Management Studio, SQL Server Enterprise Manager

Operating Systems: MS-DOS, UNIX, MS-Windows 95/98/NT & 2000, Virtual Machines

Others: SSAS, SQL Profile, Erwin, Light Speed, Red Gate, SQL Server Configuration Manager, SQL Server Surface Area Configuration.

PROFESSIONAL EXPERIENCE;

Confidential, Irvine CA.

Sr.SQL Server DBA

Responsibilities:

• Experience in Installing, Upgrade and Migrating SQL 2005, 2008, 2012 and 2014 Databases.
• Worked in the agile environment as SQL Developer to perform the tasks required to administer, develop, maintain and monitor all enterprise databases.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Hands on experience in SQL Server 2014 for data tier like stored procedures, functions, locks and performance tuning.
• Extracted and transformed data from one server to other servers using tools like Bulk Copy Program (BCP), BULK INSERT, and SSIS.
• Good hands on experience in Mapping and back filling of various systems for Confidential systems.
• Strong knowledge in High Availability\DR solutions - Mirroring and Clustering (Logshipping,Replication & Always ON will be an added advantage).
• Knowledge and experience on DB maintenance tasks.
• Experience implementing and documenting manual and automated administrative database tasks such as automated database backups, email and SMS job notifications.
• Experience setting up a complete database, including designing, implementing, and documenting the schema (tables, views, stored procedures, and so on), after analyzing user requirements.
• Work with Enterprise Architect and Technical Leads to establish database coding standards.
• Creates and maintains all databases required for development, testing education and production usage.
• Works with Technical Lead, Business Analysts, and Project Managers to translate design into product, including programming, testing, andimplementation.
• Experience in TFS for maintaining Code. Maintaining the Database Source Code Control and versioning using Microsoft Visual Source Safe.

Environment: Microsoft SQL Server 2000\2005\2008\2012\2014, SSIS, Windows 2003/2008, Visual Studio 2005\2012\2013, Business Intelligence development studio 2005 .

Confidential, Irvine, CA

Senior SQL Server DBA

Responsibilities:

• Upgraded migrated all SQL 2000/2005 Servers to 2008/2012/2014. Virtualized 90% servers from physical to VM and Implemented Always-ON and Replication.
• Implemented standalone server to high availably/DR using Always on and Storage Replication.
• Created Standard Documents SQL server Master Inventory/Installation, Replication, Always on Setup, Deployment procedure, DBA cook book and RACI/RCA.
• Worked with Internal/External Auditors to make all Database servers are SOX compliance and we made all Database servers 100% compliance.
• Consolidated Databases and servers and virtualized many servers from Physical to VM and saved server cost and license cost.
• Knowledge and work experience in Views, Triggers, Stored Procedures, Indexes, Constraints and User Defined Functions.
• Actively involved in capacity planning/requirement analysis.
• Imported data from different data sources into SQL server database using SSIS.
• Extensively worked on performance tuning and application design, hot backups, cold backups, disaster recovery planning, security management and managing servers.
• Configured Active-Passive clustered environment on windows 2008 R2/2012.
• Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers and user-defined functions.
• Identified, tested and resolved database performance issues by monitoring and tunning, to ensure data optimization.

Environment: Microsoft SQL Server 2005\2008\2012, SSIS, SSRS, Windows 2003/2008, Business Intelligence development studio 2005.

Confidential, Tampa, FL

SQL Server DBA

Responsibilities:

• SQL server 2008, 2008R2 & 2012 installation and maintenance in a 24x7 environment, setup production/test/development environments for multiple projects.
• Designed and implemented SQL server 2012 always ON availability groups for high availability.
• Expertise in development of automated daily, weekly and monthly maintenance jobs such as backups restores, rebuild indexes and update statistics.
• Good knowledge in resolving locks, deadlocks, handling isolation levels and concurrency effects, detect CPU,I/O, memory bottlenecks.
• Performed Database upgrades of production, Development and test databases from SQL 2005 to SQL Server 2008 R2/2012.
• Checking the indexes and defragmentation level of the indexes for optimal performance.
• Expertise in analyzing, identifying and resolving Database issues such as Dead locks and Blocking by using SQL DMV’s.
• Created several active directory groups and service accounts for SQL Server.
• Worked closely with Development team to deploy SSIS packages, Object schema changes to Production servers.
• Used Lite speed for Backups and restoring the databases.
• Regular updates with service packs and Performed the health checks of database.
• Provided 24x7 production database on call support.

Environment: Microsoft SQL Server 2008/2008 R2/2012, Windows Server 2003/2008/2008 R2/2012, SQL Server 2012 Alwayson, Lite Speed.

Confidential

SQL-SERVER DBA.

Responsibilities:

• Performed migration of SQL instances and databases from MS SQL 2005/2008 TO MS SQL 2008/2008 R2.
• Setup SQL native backup jobs for efficient recovery by setting up differential and more frequent transaction log for more dynamic databases.
• Created database maintenance plans for the performance of SQL server, which covers database integrity checks, update database statistics and re-indexing.
• Automated data collection from multiple sources per business requirement to monitor disk space, log space and data file space used and old usage.
• Implemented new features like policy based management, table compression, backup compression, SQL server auditing, resource governor and MERGE statement in T-SQL.
• Used power shell scripting for setting up Mirroring jobs on the server.
• Worked with application team to design best archive plan for large databases to improve performance and reduce disc cost.
• Involved in monitoring and resolving replication issues.
• Checking for consistency of tables in database.
• Experience in deploying and migrating SSRS reports.
• Developed complex queries, stored procedures and constraints, triggers for various applications.
• Involved in creation of T-SQL queries and stored procedures.
• Used dynamic management views (DMV) and profiler for monitoring and troubleshooting for the performance of production server.
• Documented and maintained all servers, databases and jobs.
• Population of database master tables with data as per the requirement of development team.
• Managed security using logins and roles of various users.
• Trouble shoot server issues on day to day basis with providing 24x7 supports for production environment.

Environment: MS SQL Server 2005, 2008/2008R2, Windows 2003/2008, SQL, MS Access.

Confidential

ENGINEER - IT

Responsibilities:

• Configured and maintained MS SQLserver2000/2005 servers with latest service packs, performed all administration tasks including backups, availability monitoring and disk space management.
• Monitoring SQL server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Responsible for monitoring and making recommendations for performance improvement in hosted Data bases. This involved index creation, index removal, index modification, file group modification, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers and user-defined functions.
• Managed trouble shooting of client connections, viewing error log and applications.
• 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 the privileges to users and groups.
• Implemented log shipping between two instances of servers using database maintenance plan by creating a monitor server and a shared folder.
• Involved in weekly change management, in which code developed by developers is run on production server.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Managed securities using logins and roles.
• Created scripts for backups and cleanup jobs.
• Used data partitioning and snapshot isolation in SQL server 2005.
• 24x7 production database on call support.

Environment: MS SQL Server 2005, Windows 2003.