PROFESSIONAL SUMMARY:

• Microsoft Certified DBA SQL Server 2008
• Over 10 years of IT experience in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 7.0/2000/2005/2008 R 2/2012/2014/2016 databases in Production, Staging, and Development Environments
• 24 X 7 Production Database On Call Support
• Proficient in installation of SQL and Oracle servers
• Proficient in Linux
• Proficient in AWS RDS and EC2 and Microsoft Azure
• Proficient in performance tuning
• Proficient in database encryption - currently implementing TDE
• Proficient in SQL Server database administration activities like Installation, Configuration, Database Design, Security, Backup, Recovery, Roles and User Permissions
• Upgrade the Production, Testing and Development databases from SQL Server 2005 and 2008 Enterprise version to SQL Server 2012 Enterprise version and 2014 Standard version
• Proficient in SQL Server SSIS, SSRS and SSAS
• Proficient in IIS server, Power shell and Server Capacity Planning
• Experienced in SDLC, E-R Data Modeling (ERD) and Multi-Dimensional Modeling in creating Star Schemas and Snowflake Dimensional Schemas using Erwin Data Modeler
• Proficient in Disaster Recovery mechanisms such as Log Shipping, Database Mirroring, Replication and Microsoft Failover Clustering
• Proficient in database migration from SQL servers 2000, 2005, 2008 to 2008R2,2012 and 2014
• Configure replication on the production servers to offload reporting. Proficient in implementing different types of Replication models like Snapshot, Merge and Transactional replication on production environment
• Excellent knowledge with SQL Server storage structures and security architecture residing on SAN databases
• Proficient in creating maintenance plans for database consistency checks, indexes/statistics and performed fine tuning of database applications
• Experienced in creating Business Intelligence Reports using SSRS 2008R2, 2012 and 2014
• Solid experience in designing report layouts in SSRS and deployed cubes using SSAS
• Proficient in performance tuning, query optimization, troubleshooting, scheduling jobs and alerts
• Proficient in monitoring event viewer, SQL error logs and log file viewer for Software and hardware related errors
• Proficient in creating stored procedures, triggers, views, functions, packages, indexes, complex queries using joins and sub queries in T-SQL
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs
• Good knowledge on statistical software R and SPSS
• Good understanding of organization goals and objectives

TECHNICAL SKILLS:

Skills: Microsoft SQL Server 7.0/2000/2005/2008 /2008R2/2012, 2014 ORACLE 11g and 12c, Windows 95/98/NT/XP/ 2000/2003/2008/2008 R2/2012/2016,UNIX, Linux, Oracle 8i/9i/10g/11g,12C, SPOTLIGHT, IGNITE - SOLARWINDS, REDGATE, Access, SQL, PL/SQL, T-SQL, HTML, DHTML, XML, Power Shell, MS Visual Studio, IIS, SSRS, SSIS, SSAS, DTS, SQL Profiler, DMV, MS Visio.

EMPLOYMENT SUMMARY:

Confidential, Stamford, CT

Sr. Database Administrator (DBA)

Responsibilities:

• Planned to install POWER BI DESKTOP on AZURE
• Install SQL Server clustering in production, QAand development environments
• Maintain cluster and apply service packs, troubleshoot
• Setup replication and mirroringmaintain and troubleshoot.Successfully implemented and monitored transactional replication with updateablesubscribers on production environment with publisher, distributor and subscriber topologies
• Setuplogshippingfor DR, maintain and troubleshoot
• SetupAlwaysOnon production servers
• Upgrade Production, Staging and Development database servers from SQL Server 2005 and 2008r2 Enterprise version to SQL Server2012 Enterprise version
• Performance reporting with Perfmon, Profiler
• Excellent knowledge in performance tuning.Testing and troubleshooting all the problems relating to database and servers performance using perfmon, profiler and DMVs
• Extensively use Execution plans, Engine Tuning Advisor and other query optimization practices
• Set up indexes for better performance of databases
• Extensive experience in Backup and Restore Strategies and possess extensive knowledge of SQL Server 2005, 2008, 2012 and 2014
• Extensive experience in controlling the user privileges, monitoring the security and Audit issues
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Reporting services SSRS - creating reports, deploy and trouble shooting
• Create and deploy SSIS packages
• Deploy oracle andmysqlscripts

Environment: MS SQL Server 2005/2008, 2008R2,2012 and 2014 MS Windows Server 2003/2008/2012 , 2012R2,SSAS, SSIS, SSRSORACLE 11g, 12C, Unix,MYSQL,TIVOLI,Visual Studio 2008, 2012, ASP.NET, T-SQL, XML, RedHat Linux 5 and 7

Confidential, Port Washington, New York

Sr. Database Administrator (DBA)

Responsibilities:

• Install SQL Server, 2008R2, 2012 and 2014 versions in production, staging and development environments
• Implemented Transparent Data Encryption (TDE) for multiple projects
• Install cluster and maintain - apply service packs, troubleshoot
• Setup replication, maintain and troubleshoot.Successfully implemented and monitored transactional replication with update subscribers on production environment with publisher, distributor and subscriber topologies
• Setuplogshippingand mirroringmaintain and troubleshoot
• Setup clustering andAlwaysOnon test servers for use in production
• Setting-up Hadoop for testing and future use (in progress)
• Upgrade Production, Staging and Development database servers from SQL Server 2005 and 2008r2 Enterprise version to SQL Server2012 Enterprise version
• Install ORACLE 11g, 12C on Linux and Windows
• Designing data migration from ORACLE to SQL and vice versa
• Performance reporting with Perfmon
• Applied RMAN backup of database
• Excellent knowledge in performance tuning.Testing and troubleshooting all the problems relating to database and servers performance using perfmon, profiler and DMVs
• Extensively use Execution plans, Engine Tuning Advisor and other query optimization practices
• Set up indexes for better performance of databases
• Extensive experience in Backup and Restore Strategies and possess extensive knowledge of SQL Server 2005, 2008, 2012 and 2014
• Extensive experience in controlling the user privileges, monitoring the security and Audit issues
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Reporting services SSRS - creating reports, deploy and trouble shooting
• Create and deploy SSIS packages
• Resolve issues and version conflicts during the database migration and upgrade techniques
• Design ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS, CDC
• Designing the new Data warehouse while constructing the cubes and dimensions of a system for the purpose of analysis, decision making based on historical data

Environment: MS SQL Server 2005/2008, 2008R2.2012 and 2014 MS Windows Server 2003/2008/2012 , 2012R2, ORACLE 11g, 12C, SSAS, SSIS, SSRS, Unix, MYSQL, Visual Studio 2008, 2012, ASP.NET, T-SQL, XML

Confidential, San Antonio, Texas

Sr. SQL Server DBA

Responsibilities:

• Responsible for MS SQL Server 2005, 2008, 2008R2 and 2012 configuration, tuning and provided 24 X 7 dedicated support to production, testing and development environments
• Installed SQL Server 2008R2and 2012 in production and development environments
• Upgraded the Production, Testing and Development databases from SQL Server 2000 Enterprise version to SQL Server 2008 Enterprise version, 2008 servers to 2008R2 and 2008R2 to 2012
• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2005
• Used Redgate to reduce storage requirements, reduce backup times and speed recovery duration using high performance compression technology
• Performed Full, Differential, Transactional log and File grouped backup of databases and restore them as needed.
• Implemented database encryption using TDE (Transparent Data Encryption)
• Monitor performance using SQL Profiler, Perfmon and used a monitoring tool calledSpotLight.
• Build, deploy and automate SSIS packages on production server
• Made various SSIS packages (ETL, SCD, Data Migration, Data Refresh), deployed them and automated on a recurring basis
• Responsible for data integration, data cleansing and de-duplication
• Troubleshoot SSIS packages
• Restore and recover corrupted databases like suspect, corrupt and the like
• Review and tune up SQL queries, stored procedures, views, triggers
• Assigned permission to user(s), role(s), and object. Supported column level permissions and administrated security for server’s logins (Windows and SQL Accounts)
• Maintained the security, integrity and availability of MS SQL Server 2000, 2005, 2008 and 2008R2
• Created Linked Servers between SQL Server 2000, 2005, 2008R2 and OLE DB data sources
• Involved in performance tuning, optimization of stored procedures and T-SQL queries
• Used Perfmon for performance reporting
• Introduced Exception Handling

Environment: MSSQL Server 2000, 2005, 2008, 2008R2 and 2012, SSIS, SSRS.Sotlight, Redgate, Oracle 10g, SQL Examiner, Visio

Confidential, Boise, Idaho

MS SQL DBA (consultant)

Responsibilities:

• Migrated databases to SQL server from heterogeneous sources
• Implemented Transparent Data Encryption (TDE) on some production databases
• Installed SQL Server 2008 in production, test and development environments
• Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies
• Designed and implemented database changes
• Reviewed and tune up SQL queries, stored procedures, views, triggers
• Provide and design tools to assist in the management of the database and transaction processing environment
• Performance tuning of databases
• Help in-house developers improve performance of their stored procedures, TSQL codes and database design
• Managed health of SQL Servers including backups, restores, monitoring
• Provide a working model of our transaction processing environment for capacity assessment and planning.
• Developed a methodology for the ongoing assessment of database performance and the identification of problem areas
• Develop a security scheme for the database environment, as well as assisting in disaster recovery if necessary
• Provided technical support during the development and enhancement of production databases, technical support and operations during the design, development and implementation of databases
• Worked with the transaction processing area to develop both the physical and the logical database administrations functions
• Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process
• Worked with vendors in evaluating and implementing new technologies

Environment: MSSQL Server 2000, 2005 and 2008, MS Windows Server 2000, 2003, 2008, SSIS, SSRS, SSAS, .NET, VISIO, Oracle 10g/11g

Confidential, Basking Ridge, NJ

SQL DBA/Developer

Responsibilities:

• Installed SQL Server, 2005 and 2008 in production and development environments
• Installed oracle 9i, 10g server and client - database creation, creating users, privileges
• Upgraded the Production, Testing and Development databases from SQL Server 2000 Enterprise version to SQL Server 2008 Enterprise version, 2008 servers to 2008R2
• Extensive experience in Backup and Restore Strategies and possess extensive knowledge of SQL Server2005, 2008
• Extensive experience in controlling the user privileges, monitoring the security and Audit issues
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Good knowledge in planning and enhancing the Windows 2003 Active Directory environment and applied access controls and other security safeguards for the implementation of management tools
• Experience in Change Data Capture and Policy Based Management in SQL Server 2008 Environments
• Excellent knowledge in Windows SharePoint Administration and Development environments
• Resolved issues and version conflicts during the database migration and upgrade techniques
• Successfully implemented and monitored transactional replication with update subscribers, implemented snapshot replication on production environment with publisher, distributor and subscriber topologies
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS
• Converted various stored procedure based reports in SSRS to improve the efficiency and flexibility of the system
• Good knowledge in Foreign key constraints and Referential Integrity checks to maintain the optimal performance
• UsedLiteSpeed5.0 to reduce storage requirements, reduce backup times and speed recovery duration using high performance compression technology
• Modified the stored procedures in SQL Server 2005/2008 in order to achieve optimal performance
• Designing the new Data warehouse while constructing the cubes and dimensions of a system for the purpose of analysis, decision making based on historical data

Environment: MS SQL Server 2005/2008, MS Windows Server 2003/2008, SSAS, SSIS, SSRS, Unix, Oracle 10g/11g, Red Gate, Visual Studio 2008, ASP.NET, T-SQL, XML, ERWIN,XymonandLiteSpeed5.0