SUMMARY:

• Over 10 years of experience in Database Administration, Design, Architecture and development as an operational/Infrastructure SQL Server DBA supporting SQL 2000/2005/20 /2014/2016 and MS access. Worked with Public sector companies like Confidential, Molina Healthcare.
• Work Experience in Major Industrial Sectors such as Health Care, Financial Services, Insurance Services, Manufacturing and Technology.
• Hands on Experience in Architecting, Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008/2008 R 2/2012/2 standalones and Failover Clusters both on Physical and Virtual environments (On - Premise and cloud).
• Hands on experience in migrating database from MS access to MS SQL server.
• Planning and Designing DB Servers with thorough understanding of underlying Hardware, To Architect Database Servers including Sizing, Capacity planning with thorough understanding SAN/RAID levels by working with SAN team for IO Optimization , Bench marking and Implementation of DR/HA strategies within SQL Server in accordance with RPO/RTO meeting SLA's.
• Experienced in supporting databases hosted in cloud, both IAAS and PAAS (AWS and Azure).
• Served as a Primary DBA for HIPPA/SOX Complaint Applications for several years working with Internal as well as external Auditors.
• Thorough understating of Windows Clustering (Failover) concepts and experienced in Configuring/Optimizing Software Based SAN (Iscsi) using StarWind Software and Windows Server ISCSI for building POC SQL Server Clusters using VMWare .
• Basic understanding of Oracle/MySQL/PostGres DBA concepts and provided Mysql backup Support as well as needed.
• Experience in Code Optimization and Improving Efficiency in Databases.
• Solid experience and outstanding knowledge of high availability and Disaster Recovery solutions for SQL server, including clustering services, Mirroring, Always ON Availability Groups, Log Shipping and Replication.
• Solid understanding of SQL Server Internals and outstanding administration skills including B ackups/Recovery, D atabase maintenance, Security maintenance, Troubleshooting, Performance tuning etc.
• Extensive experience with SQL Server and T-SQL in constructing Triggers, Tables, Functions, Indexes, Stored Procedures.
• Extensive experience of administering/maintaining MSBI solutions - SSIS, SSRS and SSAS.
• Extensive experience in D ata Extraction, Transformation and Loading(ETL) Using SQL Server Integration Services(SSIS) in SQL Server 2014/2012/2008/2005 and DTS in SQL 2000.
• Solid experience with third Party tools for supporting SQL Server Databases like Quest, Idera, EMC DDBoost and Red Gate.
• Very enthusiastic to explore new technologies/product enhancements and to mentor other team members as necessary.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2000/2005/2008/2008 R 2/2012/2 /2019 , Oracle10g/11g and MySQL 5.1, PostgreSQL and MS Access.

Operating Systems: Windows 95-98/Me/XP, Vista/7/8/10 and Windows Server 2000/ 2003/2008/2008 R2/2012/2012R2/2016 and RHEL.

Languages: T-SQL, Windows batch Scripting, Power Shell, C, C++, and PL/SQL.

Web Technologies: HTML, XML, IIS (5.0/6.0/7.0)

Proficient Tools and Software/Services: SQL Server Management studio, SQL Server Enterprise Manager, SQL Server Business Intelligence Development Studio (BIDS), Azure Data Studio, SQL Server Data Tools, SSRS, SSIS, SSAS, Microsoft Azure, Amazon AWS/RDS, Visual Studio, SQL Server Migration Assistant(SSMA),TOAD for SQL Server, EMC DDboost, Oracle Enterprise Manager, SCOM, MS-Office 2007/2010/365 Suite, Quest LiteSpeed, Quest Capacity Manager, Quest Spotlight, Quest Fog light, Idera SQL Doctor, Idera SQL Secure, Red Gate SQL Compare, Red Gate SQL backup.

Operating Systems: Windows 95-98/Me/XP, Vista/7/8/10 and Windows Server 2000/ 2003/2008/2008 R2/2012/2012R2/2016.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Sr. SQL Server DBA

Responsibilities:

• Install, configure and maintain servers/databases both in Physical and VMWare Virtual environments, working with Windows/Networking/Storage teams to ensure databases and the servers are always available with minimal down time.
• Installation and configuration of MS access databases, migrated data from MS access to SQL server.
• Perform database upgrades and migrations from older (SQL/2005/2008R2) versions to newer supported versions (SQL 2014/2016).
• Perform database tasks automation by scheduling Jobs, SSIS packages and SSRS reports using SQL Server Agent service and Windows task scheduler/PowerShell scripts.
• Develop SQL Server database environment standards and best practices adhering to Microsoft recommendations.
• Perform database maintenance and Optimizations on a regular basis ensuring the databases are running efficiently without any consistency errors.
• Create, test and deploy both data (Data Manipulation) and structural (Data Definition) code changes in databases as per the requirements using Batch scripts, T-SQL and PowerShell scripts.
• Work with developers and end users to identify business needs and deploy database objects, perform Performance Tuning Optimizations for SQL code as needed.
• Participate in code reviews with application teams and product vendors as needed and deploy database changes to Staging and Production environments in accordance with Software Development Life cycle.
• Monitor database performance metrics, responsible for setting up SQL Server alerts and daily health reports and troubleshoot any errors being proactive, ensuring the database servers are optimally functioning for end users using Native SQL tools such as Profiler and DPA (Database Performance Analyzer) and SQL tools.
• Participate in quarterly DR tests and 24/7 On-call rotations.

Environment: SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016 , SSRS, SSIS, SSAS, SQL Server Data Tools, VMware vSphere, SQL profiler, EMC DDBoost, Windows Server 2003/2008/2008 R2/2012/2016,mysql, PostGresSQL,MS access.

Confidential, Irvine,CA

Principal DBA(Lead)

Responsibilities:

• Performance tuning and optimization of various SQL Server environments 2008R 2/2012/2014.
• Expertise PL/SQL for implementing business logic by writing complex stored procedures, triggers, cursors, indexes, functions and designing tables, databases on file groups and also with PowerShell programming.
• Installation and configuration of SQL Server 2012 and 2014 with always-on.
• Created SSRS reports for leadership team to know about infrastructure details and other projects.
• Created SSIS packages in data movement from Oracle to SQL and vice versa.
• Created cubes in SSAS to analyze the financial reports.
• Implemented in-memory OLTP and column store indexes for 8 TB DB and migrated from SQL2012 to SQL2014.
• Implemented central management system (CMS), which monitors all production systems from one place. This server generates automatic alert for database growth, Backup failures, Job failures, Memory status, long running queries, CPU pressure etc.
• As Onsite and offshore coordinator, responsible in handling 450 instances and initiating new projects and taking care of critical issues.
• Implemented monitoring tools for managing SQL environment. As part of implementation configured spotlight, Foglight and lightspeed in all environments (QA/PROD).
• Migration of servers from SQL 2005, SQL 2008R2, SQL 2012, SQL2014 to SQL 2016.
• Supporting application team in setting up their development environment.
• Involved in requirement analysis and capacity planning for database design, maintenance.
• Worked with SAP application team in planning and implementation of a four different land scape sandbox, development, quality and production.
• Automated SQL SERVER post installation steps by PowerShell and T-SQL scripts.
• Administered SQL Server 2012 using always-on and maintained user logins with appropriate users/groups/roles and granting the privileges to users and groups.
• Implemented Database mirroring for ESB system with High Performance Mode.
• Provided 24X7 production database support for SQL Server databases.
• Created scheduled jobs to automate routine housekeeping tasks.
• Engaged in backup, restoration and recovery operations.
• Planned and implemented database security measures.
• Developed a tool which verifies whether a backup is moved to tape or not. This will avoid the confusion.
• Was involved in fine tuning stored procedures and queries

Environment: SQL 2014, SQLSERVER 2012, 2008R2, MySQL, Oracle 11g, TFS ( Team Foundation server), Dell performance monitoring tools (SPOTLIGHT and FOGLIGHT), Appmon, Netreo, TOAD and Omni.

Confidential, FL

Database Analyst(Lead)/DBA

Responsibilities:

• Installed and configured SQL Server 2008 R2 databases with cluster and non-clustered environment.
• Worked on Transactional replication for 10 TB size of the applications.
• Mentor developers on coding / implementation issues.
• Was involved in requirement analysis and capacity planning for database design, maintenance.
• Installed SQL Server and applied service packs and hot fixes.
• Carried out data migration to SQL server platform.
• Involved in running DTS Import/Export for transferring data to SQL Server databases.
• Linked legacy applications to SQL Server databases.
• Administered SQL Server 2008 R2 by creating user logins with appropriate users/groups/roles and granting the privileges to users and groups.
• Provided 24X7 production database support for SQL Server databases.
• Created scheduled jobs to automate routine housekeeping tasks.
• Engaged in backup, restoration and recovery operations.
• Planned and implemented database security measures.

Environment: SQL Server 2008 R2, SQL2005, SQL2000, Oracle 11g, Quest performance Management, VBA

Confidential, Long Beach, CA

Senior SQL Server Database Administrator

Responsibilities:

• Engaged in daily database administration tasks including consistency checks, space management, object alterations, database backups, job schedules, and maintenance plans.
• Provided 24X7 production database support for SQL Server as primary contact person.
• Designed and implemented complex databases and carried out SQL server installations.
• Implemented database mirroring.
• Configured various database replication topologies.
• Worked on SQL server cluster shared environments.
• Engaged in backup, restoration and recovery operations.
• Was responsible for monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, and enabling database level trace for performance tests.
• Managed user creations, assigning roles to SQL Databases.
• Extensively involved in maintaining and updating the database documentation.
• Was involved in requirement analysis and capacity planning for database design, maintenance.
• Installed SQL Server and applied service packs and hot fixes on a routing basis.
• Planned and co-coordinated database security measures.
• Developed T-SQL Scripts (SQL 2000/2008) for various support functions.
• Scheduled SSRS packages for deployment.
• Built QNXT servers for Health care Claim processing project.

Environment: SQL Server 2000, SQL Server 2008r2, WebSphere, Microsoft.Net and Quest performance Management and Lite speed for backups.

Confidential

Database Administrator

Responsibilities:

• Provided administration for SQL server 2005 production database servers
• Migrated one of the critical product from Postgres to SQL 2005
• Installed and configured Microsoft SQL Server 2005 on production and development servers in physical and virtual servers running on VMware
• Deployed security patches on SQL Server databases as they were released
• Developed and maintained maintenance plans, evaluated scheduled jobs and monitored performance during various job runs
• Designed and implemented comprehensive backup plans and disaster recovery strategies
• Scheduled nightly jobs in the SQL Server Agent to carry out the database maintenance activities such as database backups and consistency checks
• Performed restore of databases per the requests from the clients
• Configured various database replication topologies
• Deployed SSIS/SSRS/SSAS packages
• Functioned as an application DBA providing expert suggestions and solutions towards performance enhancements of SQL queries and stored procedures to the development team
• Performed routine database maintenance activities such as re-indexing so as to ensure a good performance on the SQL Servers
• Used Windows Performance Monitor and SQL Profiler to optimize queries, resolve dead lock issues and enhance the performance of database servers.
• Installed, configured and monitored Active/Active clustered servers created and maintained database security, logins, users, roles and user permissions.
• Got involved in troubleshooting various database connectivity issues from the client application
• Functioned as the team lead and coordinated the activities between the onsite and offsite teams
• Was responsible for status reporting to the client on a weekly basis

Environment: SQL Server 2000, SQL Server 2005, MS-Reporting Services, XML, ASP.Net, VB Script, Postgres, C#.net.

Confidential

SQL Server DBA/ Developer

Responsibilities:

• Started as a SQL Developer and evolved into a DBA role
• Wrote stored procedures to implement business logic to maintain the history of entities which was also passed on to the application via Stored Procedures
• Improved the performance of SQL Queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard
• Transferred data from flat files, Excel spreadsheets to and from SQL Server using DTS, BCP and Bulk Inserts
• Involved in monitoring and optimizing the performance of the database and planning for backup and recovery of database information
• Maintained archived data on tape and Backing up and restoring the database
• Created and managed users, roles and groups and handled database security
• Managed test data and their updates between development and production databases
• Worked in installation, configuration, design and implementation of staging database for data migration and data entry
• Maintained DTS packages and SQL server agent jobs
• Worked on designing the database schema
• Was involved in creation of reports using stored procedures and views
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes

Environment: SQL Server 2000, SQL2005, MS-Reporting Services, VB, VB.Net, ASP.net, C#.net