SUMMARY:

• Over seven 7+ years of extensive experience. Involved in database administration, database architecture and configuration, analysis, tuning, data migration, development and support of SQL Server 2012/2008 - R 2/2008/2005. Extensive experience in Analysis, Design and Development of various applications using SQL Server.
• Worked on the SQL Server 2012, 2008-R2/2008, 2005 and 2000 installation addressing the evaluation of installation requirements, designing the installation, planning scale up versus scale out basics, shrinking and growing databases, and designing the storage for new databases.
• Installed SQL Server and Related Services engaging on the configuration of an Operating System Disk, installation of the SQL Server Database Engine, SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Analysis Services in virtual and physical environments, providing 24/7 support both production and non-production environment.
• Installed service packs, security updates and hotfix in SQL Server 2000, 2005, 2008-R2/2008, and 2012.
• Worked on SQL Server 2012 migration from SQL Server 2008-R 2/2008/2005.
• Managed database permissions on the securable, on objects, and managing permissions by using database roles.
• Managed SQL Server Agent executing Jobs by using SQL Server Agent, managing alerts, managing jobs, and monitoring multi-server environments.
• Experienced in restoring SQL Server databases performing the databases restores, file restores, page restores, restoring a database protected with transparent data encryption, restoring system databases, and restoring replicated databases.
• Experienced in Performance Monitoring and Tuning, Query Optimization via T-SQL, DMVs, System Monitor, DBCC Utilities, Database Tuning Advisor/Index Tuning Wizard, and SQL Profiler.
• Expertise in T-SQL writing stored procedures, triggers and functions and creating indexes.
• Performed the troubleshooting of production issues and raising high availability implementing database mirroring, log shipping, and replication.
• Experienced in high availably SQL server solution, including clustering and AlwaysOn.
• Developed and documented database migration strategies, ETL using SQL SSIS, Import/Export and BCP utilities.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, contained databases, security principals.

TECHNICAL EXPERTISE:

Databases: MS SQL Server 2012, 2008-R2/2008, 2005, 2000, and MS-Access

Programming: Transact SQL

SQL Server Tools: Management studio, Profiler, Query Analyzer, Import and Export, DTA, SSIS, Replication, Analysis services, Reporting services, & Integration Services.

Operating System: Windows servers 2012/2008-R2/2008/2003 Advanced Server, NT & Windows

Third party Tools: Red gate, SQL Litespeed, and spotlight

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

SQL Server DBA

Responsibilities:

• Worked on the SQL Server 2012 and 2008-R2/2008/2005 installation addressing the evaluation of installation requirements, designing the installation, planning scale up versus scale out basics, shrinking and growing databases, and designing the storage for new databases.
• Installed SQL Server and Related Services engaging on the configuration of an Operating System Disk, installation of the SQL Server Database Engine, SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Analysis Services.
• Performed the migration of database from SQL server 2008-R2/2008/2005 to SQL Server 2012.
• Managed database permissions on the securable, on objects, and managing permissions by using database roles.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing and contained databases.
• Implemented transactional replication and merge replication for high availability of the databases in SQL Server 2008 R2.
• Experienced in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Implemented AlwaysOn Availability Groups and the clustered environment.
• Recovered the databases from backup in disasters and implemented Point-In-Time Recovery solutions.
• Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
• Involved in setup of maintenance plans for backups, history clean up task and rebuild indexes on all servers schedule to run at various times.
• Worked on SSRS reports to report the daily, weekly and monthly statistics of various investors.
• Used Red Gate tools such as data compare, SQL compare to keep the objects and data in sync in various environments.
• Used SQL Litespeed to perform fast, efficient backup and recovery by reducing the size of backup data at the client—before it is transferred across the network and stored.
• Interacted with Business Analysts for understanding the Reporting Requirements for different investors.
• Engaged in the suggestion and implementation of Backup Strategies and scheduled the backups for databases and transaction log across different environments.
• Involved in maintaining the security by granting permission to user(s), role(s), and object(s).
• Administered security for server’s logins (Windows and SQL Accounts).
• On call 24/7 support to databases on weekly rotation.

Environment: SQL Server 2008/2008-R2/2012, Windows Server 2012/2008R2/2008, Clustered, SSIS, T-SQL, and others.

Confidential, Bedminster, NJ

SQL Server DBA

• Installed SQL Server 2008 and SQL Server 2005 on windows servers 2003 and 2008, applied service packs and security fix for all servers.
• Successfully Upgraded most of the SQL Server from SQL 2005 to MS SQL Server 2008.
• Experienced in performance tuning very large databases.
• Developed monitoring and alerting functions related to SQL server.
• Applied security best practices and methodologies.
• Developed and applied SQL performance related tools and functions.
• Performed routine database management.
• Successfully performed backup and restore databases.
• Operated troubleshooting of the SQL Server issues.
• Created Database Maintenance plans, SQL Agent jobs, and stored procedures and SSIS packages.
• Provided on call support for a large SQL Server implementation.
• Utilized SQL Server Management Studio to provide monitoring, administration and configuration management on database engines.
• Communicated with a wide variety of technical and business experts in both individual and group settings using email, self-generated documentation and presentations.
• Performed login management, install/patch, troubleshoot connectivity issues, monitor performance and tune in complex three-tier architectures.
• Maintained, created, and monitored various ETL processes.
• Experienced in troubleshooting, performance tuning, index tuning using DBCC command, Wizards and SQL Profiler.
• Managed many SQL Servers in a 24x7 Production environment.

Environment: SQL Server 2008/2005, Windows Server 2008/2003, SQL Query Analyzer, SQL Profiler.

Confidential, NY

SQL Server DBA

• Installed and maintained SQL Server database systems by ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Involved in migrating from SQL Server 2005 to 2008 R2.
• Updated database systems by reviewing, planning, testing and installing database security patches and service packs.
• Designed, documented, and promoted security "best practices", policies, standards and protocols
• Deployed maintenance plans for regular DBA activities .
• Worked with development and systems teams to perform application and database tuning
• Involved in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILERand ACTIVITY MONITOR for performance analysis.
• Handled Memory configurations for SQL Server 2005/2008R2 on Windows 2008R2.
• Created Documentation for steps needed to be taken while upgrading the SQL server 2005 to SQL server 2008R2.
• Provided database highly available and application infrastructure according to Business Continuity requirements using SQL clustering, etc.
• Checked Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning
• Recovered the System and User databases from suspect mode, Expert in sizing Temp database.
• Prepared Documentation for the Disaster Recovery plan. Worked in Active passive cluster environment.
• Extensively worked on trouble shooting and fine-tuning of databases for its performance, Rebuilding indexes with different fill factors and update statistics manually.
• Designed and implemented comprehensive Backup plan and disaster recovery.
• Daily routine Developer/DBA tasks like handled user’s permissions and space issues on Production and handled maintenance Jobs including backups and restores.
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations
• Monitored SQL server performance using profiler to find the performance and dead locks.
• Worked on call 24/7Support on weekly basis

Environment: SQL Server 2005/2008R2 with clustering, Replication, T-SQL, Windows 2008 64-bit, Profiler.

Confidential, Atlanta, GA

SQL Server DBA

• Created and managed schema objects such as Tables, Views, Clustered and Non-Clustered Indexes and referential integrity depending on user requirements and
• converting them into technical specifications.
• Responsible for MS SQL Server 2000 configuration, tuning and provide 24 X 7 dedicated support to all Production, development and clustered servers.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Configured the Log shipping and created the Standby server.
• Created the logical and physical data modeling using Erwin tool.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Monitored connections, locks and performance of SQL server.
• Assigned permission to users, roles and object, Supported column level permission. Administered server’s logins (Windows and SQL Accounts).
• Created and granted permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.

Environment: MS SQL-Server 2000, DTS, Erwin, Windows 2003 Server, MS Access, ASP, PERL, MS Analysis Services, Diagnostic Manager, Linux.

Confidential, BOSTON, MA

SQL DBA

• Installation and configuration of SQL Server 2005 components in Prod/Development, and UAT.
• Installing and configuring Windows 2003 fail over cluster for SQL 2000& 2005.
• Migration of windows Cluster and implementation MS SQL 2000 to MS SQL 2005.
• Migrated DTS packages to MS SQL 2005 SSIS Packages and troubleshooting migration issues and compatibility.
• Administration of Clustered SQL servers in 24 x 7 Windows data center environment.
• Designing, testing and managing disk\tape Backups and Recovery strategies.
• Managing Log Shipping for warm stand by computers.
• Managing Replication of Data (Snapshot, Transactional, Merge method used).
• Managing SQL databases, Security, fine tuning of SQL queries, troubleshooting.
• Designing and managing SQL DTS and SSIS Packages.
• Developing SQL stored procedures, views and triggers.
• Responsible to releases from development to test to production environments.

Environment: Windows 2000 Advanced server and Enterprise Server 2003, MS SQL Server 2000/2005 and Oracle, TSQL, Erwin, Flat Files, PL/SQL.