SUMMARY

• Having 8 years of professional experience as a SQL Database Administrator in windows platforms. Experience includes System Analysis, Design and Development and Support of Microsoft SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000 on various business domains.
• Expertise in installation of MS SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000 and updating with the latest Hot fixes, Security Patches, Service Packs.
• Proficiency and expertise in Migrating Database from SQL Server 2000/2005/2008 to 2008R 2/2012/2014/2016/2017 using side by side and in place migrations.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
• Configured report subscriptions both data driven and time driven.
• Experience in migration of versions of SQL Server to the cloud platform such as Microsoft AZURE.
• Expertise in SQL Server Backup/Restore, having knowledge of upgrading SQL Servers.
• Worked on fine - tuning databases, created Clustered and Non-Clustered Indexes for tables, identified Fragmentation.
• Well Experienced in Performance Tuning (System level/Database Level) and Query optimization.
• Experience in regular maintenance activities like Query Tuning, Index rebuild/reorganize log file monitoring, temp Data Bases monitoring, handling blocking, deadlock resolutions, and fragmentation issues.
• Good understanding of RDBMS, Oracle Database architecture, designs and having performed DBA duties, such as Table Partitioning, Export/Import and Data Pump.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, User defined data types, Cursors and functions using MS SQL Server 2017/2016/2014/2012/2008 R2/2008.
• Experience and outstanding knowledge on High Availability and Disaster Recovery like Replication, Log Shipping, Mirroring and Clustering.
• Implemented "Always on Availability groups" in SQL Server 2012.
• Designed and Configured Partitioning of Tables and Indexes to Improve query performance in SQL 2008 R2/SQL 2012 especially considering memory limitations.
• Experience in maintaining a large Team, Onsite/Offshore model.
• Performance Tuning Application level for code, queries, identify slow performing SQLobjects and enhance for optimum database performance.
• Conducted RCA for database incidents and problems.
• Experience in working with DTS/SSIS (ETL) in SQL, 2000, 2005 and with SSRS2005, 2008, 2012, 2014, 2016.
• Experience of Export/Import Database Objects / Tables /data using DTS and SSIS packages.
• Experience in Installation and configuration of SSRS, SSIS and SSAS servers.
• Experience in supporting dozens of Amazon AWS implementations including Amazon EC2 (IaaS) and all Amazon RDS (DBaaS) offerings
• Thorough knowledge on SAN environments, RAID levels, VMware Environments.
• Experience using Resource Governor and Policy Based Management system for maintenance.
• Hands on experience with TFS and SharePoint.
• Experience with code reviews in order to support or maintain the database applications.
• Experience in working with Managing Backups, Disk & Drive Space issues, managing indexes.
• Provided on-call support 24x7 on a weekly rotational basis.
• Effective communication, presentation and interpersonal skills and good experience in handling Team as well as end users.

TECHNICAL SKILLS

Databases: MS SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000 , MYSQL, ORACLE.

Database Tools: Query Analyzer, SQL Profiler, Data Transformation Services, Performance Monitor, Tuning advisor, Replication, BIDS (SSIS/SSRS/SSAS)

Operating Systems: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2000/2003/2008/2012/2014.

Languages: PL/SQL, T-SQL, C, C#, Power shell.

Tools: & Utilities: SQL Trace and SQL Tuning Advisory, SQL plus, ETL, MS- Excel, Visual studio, Erwin data modeler, Power BI, SQL Developer, Toad.

Third party tools: Light speed, Fog Light, SQL sentry

PROFESSIONAL EXPERIENCE

Confidential, CA

Database Administrator

Responsibilities:

• Administrated SQL Server 2017/2014/2012/2008 R2/2008 databases in Production, Staging, QA and development environments.
• Upgraded/Migrated SQL Server 2014 to SQL 2017 and migrated SQL databases to Azure SQL database in test and Dev environments.
• Worked on migrating Oracle database to SQL.
• Actively participated in interaction with users, team lead and DBA’s and technical manager to fully understand the requirement of the system
• Performance Tuning of SQL Server 2008R2 environment with UAT load testing for capacity and performance analysis. New Application Snapshot deployment.
• Responsible for supporting over 150 SQL instances which include SQL 2000/20005/2008 R2/2012.
• Migrated Databases from SQL Server 2005 to SQL Server 2008R2/ 2012 in production and test Environments.
• Installed SQL Server 2012 Cluster and configured Always On availability group set up on Windows Server 2008R2 in Development production environments.
• Configured Monitored Supported and Troubleshooting of Database Mirroring and Log shipping for multiple databases on Geo-graphically separated cluster environments to provide High Availability and Disaster Recovery.
• Support and troubleshooting for Transactional replication.
• Designed and implemented backup plans as per the data- retention policy outlined in the BRD (Business Requirement Document).
• Supported Load Testing activity by setting up and scheduling Performance Monitor (Data Collector Sets) and SQL Server Profiler Trace and monitoring them during the activity.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Creating and managing schema objects such as Tables, Views, Indexes and referential Integrity and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005 /2008.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics
• Worked on migrating SQL Servers to Microsoft Azure cloud-based platform.
• Backup and Recovery of Production Databases and tuning them for better Performance.
• Deploying and Troubleshooting SSIS packages.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Creating new Databases and Migrated SQL Server 2005 databases to SQL server 2008R2 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.
• Moved databases from SQL Server 2005 /2008 to SQL Server 2012.
• Created Linked servers for distributed queries.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Configured database mail to inform corresponding DBA basis on each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Monitored the Performance of the SQL Server by using Performance monitor, SQL Profiler, Performance Analysis and Spotlight.
• Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active Directory Group.
• Administered, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.

Environment: SQL Server 2005/2008R2, Windows NT/2008R2/2008/2003, IBM Lombardi BPM 7.5, T-SQL, SSIS, and SSRS, ETL., Oracle

Confidential, CA

SQL Server DBA

Responsibilities:

• Installed recommended service packs and security patches on production, test and development servers.
• Designed and worked with Different RDBMS and applications collecting customers information of all BU’s into a Database and generated a Report on Customer’s overall Expenditure and Business to Cargill Agriculture business.
• Created Linked Server to Oracle 11 to open query for SSRS.
• Performance Tuning to increase the speed and performance of CargillAg.com tuning hardware and software requirements.
• Used various report items like tables, sub report and charts to develop the reports in SSRS
• Upgraded Test and Production databases from SQL 2005 to SQL 2008R2.
• In SQL 2008R2 set up Database Partitioning to improve query performance.
• Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.
• Suggested and modified code and schema changes for database objects and scripts.
• Performed a Security Audit for all SQL and Sybase servers.
• Extensive experience using Data Mining tools Microsoft Analysis Services (SSAS).
• Utilized Resource Governor to handle two applications on the Server.
• Supported and learned a very complicated Replication system between hundreds of Sybase and SQL Servers. Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler, Perfmon and Best Practice Analyzer.
• Good experience in working with high volume of transactions for OLTP & OLAP applications.
• ETL tool Running 24/7 transferring data between the SQL Servers.
• Experience in supporting dozens of Amazon AWS implementations including Amazon EC2 (IaaS) and all Amazon RDS (DBaaS) offerings
• Experience in Shell scripting (Perl, power shell).
• Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis
• Monitoring and Troubleshooting jobs, Backups and Restore database policies.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Thorough understanding of standard SOP’s, SLA’s and change control management process.
• Generating Reports as per the requirement using SSRS 2005/2008.
• Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
• Develop SSIS Packages to transform data from excel/Access file to SQL Server database.

Environment: SQL Server 2000/2005/2008 , Sybase ASE 12,15. Sybase Replication 15 MS Access, Windows NT/2008/2003 Advanced Server, Oracle, T-SQL, SSIS, and SSRS, PLSQL, UNIX, AIX servers.

Confidential

SQL DBA

Responsibilities:

• Managing and administering SQL server instances which include 2008/2008 R2/2012.
• Migration and up gradation of databases from old versions to SQL Server 2008 R2 and SQL Server 2012.
• Performed database backups and restoration as needed.
• Created SQL jobs for the backups on all the servers using a script.
• Implemented partitioning on large table to get the performance.
• Used table hints in the queries to avoid locks in the server
• Configured and worked on Database Mirrored Environments.
• Involved in configuring Always On availability groups in SQL 2012.
• Created database users same as login as well as different when requested.
• Find and fixed Orphan users during the restoration of the database.
• Created SSIS new packages and modified existed packages.
• Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.
• Upgraded few of the SSIS packages from SQL 2008 to SQL2012.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Optimized stored procedures to get the optimal performance.
• Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS.
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and updated statistics.
• Created Reports through Reporting server (SSRS) accordingly the business requirement.
• Deploy the reports on the servers where users can use.
• Created stored procedures and Functions accordingly the requirement.
• Implemented installation documents for the future reference.

Environment: MSSQL Server 2012, 2008 R2, 2008, 2005 and 2000, T-SQL, SSIS (ETL), SSRS, Erwin, Windows 2008 R2 Server, SharePoint.