Database Administrator Sql Dba
Resume:
Technical Summary
Over ** plus Years of Experience in The Database Design, Analysis, Development, Administration Support of MS SQL Server 2000/2005/2008/2008 R2/2012/2014/2016/2017/2019 In Production, Stage, QA & Development Environments.
More than 7 plus years as Production support DBA involving in On Call rotation 24/7 carrying pager
Experience in Working with Windows 2000 Advance and Enterprise Server 2003/2008/2012 R2.
Extensive Experience in Installation, Configuration & Maintenance of MS SQL Server /2017/2016/2012/2008 R2/2008/2005/2000 Versions.
Experience In Database Backup, Recovery and Disaster Recovery Procedures.
Experience in Replication environment (Transactional & Snapshot method used)
Experience in troubleshooting Mirrored database in SQL Server 2005 environment.
Experience in Setup and troubleshoot of Always-On 2019 Availability group (AG) and Distributed Availability group (DAG).
Experience in Performance Tuning. Query Optimization, Client/Server Connectivity, and Database Consistency Checks Using DBCC Utilities
Extensive experience in using Dynamic Management View (DMV) for troubleshooting performance issues
Hands On Experience in Writing & Debugging Stored Procedures and Triggers
Experienced In Creating Databases based on Functional Requirements and System Design
Experience In Assisting the Application Developers In Creating Conceptual Database Designs That Meet The Business And Technical Objectives Of Various Projects.
Experience In Code Optimization and Improving Efficiency In Databases Including Re-Indexing, Updating Statistics, Recompiling Stored Procedures And Performing Other Maintenance Tasks.
Experience In writing DTS / SSIS Packages.
Administration and support of SSRS environment
Experience In Using Performance Monitor/Profiler
Migration from SQL Server 2000/2005/2008/2008R2/2012/2016/2017/2019.
Excellent Analytical, Interpersonal and Communication Skills & Desire to Excel, Fast Learner, Hardworking and Versatile Team Player.
Design and implementation of plans for hosting complex application workloads on Microsoft Azure
Architect solutions using MS Azure PaaS services.
Experienced with deployments, Maintenance, performance and Troubleshooting database issues on Microsoft Cloud Azure
Education and Training
Master of Business Administration. Osmania University, AP
Bachelors of Commerce. Osmania University, AP
Post Graduate Diploma in Computer Application, AP
Trained SQL DBA Professional
Technical Skills
SQL Server Tools: Enterprise Manager, Profiler, Query Analyser, DTS and SSIS
Databases: MSSQLServer6.5/7.0/2000/2005/2008/2008R2/2012/2014/2016/2017/2019, MS Access/Mong DB
Programming Languages : T-SQL, PL/SQL, C
Web Technologies : Java Script, HTML, DHTML, XML.
Operating System : Windows NT, 2000/2003/Win XP Prof/Standard
Reporting Tools : Crystal Reports. SSRS MSBI PowerBI
DB Design Tools : ERWIN, Visio
Professional Experience
Employer: - Epace Technologies Inc
Client: Solix INC (Parsippany NJ) (Nov 2021-Till date)
Role: Sr Database Administrator (SQL DBA)
Solix Inc, is a business process outsourcing firm partnering with government and commercial organization conducting business process management and providing eligibility determination solutions. Solix simplify complex programs, create efficiencies to meet standards. Solix provides the right people, processes, technology and compliance solutions to help clients make timely, accurate eligibility decisions, enhance program efficiency, and improve the customer experience.
Responsibilities:
•On-call 24/7 rotational basis, working with Application team/Microsoft Team to resolve on call issues.
•Upgrade database version SQL Server 2005 to SQL Server 2019
•Upgrade database version SQL Server 2012 to SQL Server 2019
•Installation, administration, and configuration of SQL Server 2019 in cluster environment.
•Maintenance and applying services pack and hot fix on 2017/2019 in Production and development.
•Setup and configure and trouble shoot issue related to Availability Group (AG)
•Managing and troubleshooting data Replication using Transaction replication.
•Deploying schema, tables, views, store procedures using SQL Compare.
•Analyze and troubleshoot the query performance using SolarWinds Database Performance Analyzer and Spotlight to troubleshoot issue.
•Collaborate with developers to eliminate redundant code, implement effective indexes, analyze joins to improve the performance of the query.
•Developing SQL stored procedures, views, triggers, functions managing indexes using TSQL.
•Design, develop and deploy SSIS packages in ETL environment.
•Developing data source, testing and deploying reports in SSRS environment.
•Performance optimization of slow running query in OLTP and SSRS environment.
•Design and Implement security model for app team creating schema and roles to access the data.
•Provide SLAs for incident response and system availability.
•Manage SQL IaaS and PaaS Azure databases on Azure (Microsoft Cloud)
•Design and implementation of plans for hosting complex application workloads on Microsoft Azure
•Create RecoveryValut to schedule the Azure SQL VM backups.
•Create firewall Endpoints for the Business and End Users and adding Application IP’s to the Azure Vnets on Azure SQL PaaS databases
•Create RecoveryValut to schedule the Azure SQL VM backups.
•Configure Alerts/ Metrics/ Monitoring/ Disk in Azure.
•Configure DTU’s/ Elastic Pools for the databases in Azure
•Migrated all the SQL databases and App using LIFT and SHIFT to Azure.
Environment: MS SQL Server 2005/2012/2016/2019, TSQL, SSIS, SSRS SQL Profiler, Query Store, Microsoft Outlook, Visual studio 2010 Visual studio 2012, Microsoft Azure Windows Enterprise Server 2016/2019. Windows 10, SQL Compare, SolarWinds DPA, Spotlight.
Employer: - Epace Technologies Inc
Client: United Parcel Services UPS (Timonium MD) (Mar 2020-Nov 2021)
Role: Sr Database Administrator (SQL DBA)
United Parcel Service, Fortune 500 company is a shipping & receiving and supply chain management company. UPS is primarily a ground shipping services, and also offers air shipping as well. UPS also has retail Store chain which provides tools for small business and assist UPS shipments.
Responsibilities:
•On-call 24/7 rotational basis, working with Application team/Microsoft Team to resolve on call issues.
•Installation, administration, and configuration of SQL Server 2019 in cluster environment.
•Maintenance and applying services pack and hot fix on 2017/2019 in Production and development.
•Setup and configure and trouble shoot issue related to Availability Group (AG) and Distributed Availability Group (DAG) SQL 2019 Always-On environment.
•Data Center failover troubleshoot and monitor using Distributed Availability group to Business Continuity process.
•Managing and troubleshoot Asynchronous and Synchronous Mirroring Database.
•Managing and troubleshooting data Replication using Transaction replication.
•Deploying schema, tables, views, store procedures using SQL Compare.
•Analyze and troubleshoot the query performance using Query Store and SentryOne Tool
•Collaborate with developers to eliminate redundant code, implement effective indexes, analyze joins to improve the performance of the query.
•Developing SQL stored procedures, views, triggers, functions managing indexes using TSQL.
•Design, develop and deploy SSIS packages in ETL environment.
•Developing data source, testing and deploying reports in SSRS environment.
•Performance optimization of slow running query in OLTP and SSRS environment.
•Design and Implement security model for app team creating schema and roles to access the data.
•Provide SLAs for incident response and system availability.
• Manage SQL IaaS and PaaS Azure databases on Azure (Microsoft Cloud)
•Design and implementation of plans for hosting complex application workloads on Microsoft Azure
•Worked on Azure Data Factory (ADF) to create scheduling tasks and (Extract and Load) data to Azure Data Lake (ADL) from SQL Server databases and Azure VM’s
•Created and Modified reports for Azure Billing on PowerBI
•Create RecoveryValut to schedule the Azure SQL VM backups.
•Create firewall Endpoints for the Business and End Users and adding Application IP’s to the Azure Vnets on Azure SQL PaaS databases
•Create RecoveryValut to schedule the Azure SQL VM backups.
•Configure Alerts/ Metrics/ Monitoring/ Disk in Azure.
•Configure DTU’s/ Elastic Pools for the databases in Azure
•Migrated all the SQL databases and App using LIFT and SHIFT to Azure.
Environment: MS SQL Server 2016/2017/2019, TSQL, SSIS, SSRS SQL Profiler, Query Store, Microsoft Outlook, Visual studio 2010 Visual studio 2012, Microsoft Azure Windows Enterprise Server 2016/2019. Windows 10, SQL Compare, Sentry One
Employer: - Epace Technologies Inc
Client: Dresser-Rand (Olean NY) (April 2019-Feb 2020)
Role: Sr Database Administrator (SQL DBA)
Dresser-Rand is an engineering and manufacturing company owned by German conglomerate Siemens. The company designs, manufactures, and services equipment used in the extraction of petroleum and natural gas such as Compressors, turbines, diesel and gas engines, and other industrial equipment.
Responsibilities:
•Installation, administration, and configuration of SQL Server 2016.
•Maintenance and applying services pack and hot fix of 2012/2014/2016 in Production and development.
•Install and configure new environment using SQL 2016 in Always-On environment.
•Administration and troubleshooting of SQL Always -On environment.
•Setup and configuration of backup strategy for new environment using SQL Safe management console using SQL Safe.
•Setup and configuration of database mails and maintenance plans for new environment.
•Managing and troubleshoot mirroring.
•Managing and troubleshooting data Replication using Transaction replication.
•Deploying schema, tables, views, store procedures using SQL Compare.
•Design, develop and deploy SSIS packages in ETL environment.
•Troubleshooting key violation issues in lower environments using SQL data Compare.
•Developing data source, testing and deploying reports in SSRS environment.
•Developing SQL adhoc-query, stored procedures, views, triggers, functions managing indexes using TSQL.
•Performance optimization of slow running query in OLTP and SSRS environment.
•Data migrations across the environments, Dev, QA, STAGE and Production.
•Provide oversight and tactical support for processing of datasets in all environments
•Provide SLAs for incident response and system availability.
•Develop, design and maintain all project diagrams, data dictionary & documentation.
•Setup and Installation of Mongodb 4.0 on Centos7.
•Creating database on Mongodb 4.0 for Dev environment.
•Providing user access to for development and admin purpose.
Environment: MS SQL Server 2012/2014/2016/2017, TSQL, SSIS, SSRS SQL Profiler, Microsoft Outlook, Visual studio 2010 Visual studio 2012, Team Foundation Server, Windows Enterprise Server 2012. Windows 10, SQL Compare, SQL Data Compare, SQL Safe, MongoDB 4.0 Centos7
Employer: - Epace Technologies Inc
Client: State of Connecticut DSS (Hartford CT) (April 2016-March2019)
Role: Sr Database Administrator (SQL DBA)
Department of Social Services (DSS) State of Connecticut agency, providing services through its various social welfare programs catering to the needs of the people.
Responsibilities:
•Installation, administration, and configuration of SQL Server 2016.
•Maintenance and applying services pack and hot fix of 2005/2012/2016 in Production and development.
• Administration and troubleshooting of active/active SQL 2 node cluster
•Installation, configuration, and administration of Team Foundation Server (TFS)
•Upgrade 0f database from version SQL 2005 to SQL 2012 & 2016.
•Setup server level audits on SQL server instance.
•Setup, Managing and troubleshoot mirroring and log shipping
•Setup, Managing and troubleshooting data Replication using Transaction replication.
•Design, develop and deploy SSIS packages in ETL environment for file transfer and dataloads, provide by external agency.
•Support and Troubleshoot existing SSIS package failures and performance tuning.
•Developing data source, testing and deploying, reports in SSRS environment.
•Developing SQL adhoc-query, stored procedures, views, triggers, functions managing indexes.
•Performance optimization of slow running query in OLTP and SSRS environment.
•Data migrations across the environments, Dev, QA, STAGE and Production.
•Provide oversight and tactical support for processing of datasets in all environments.
•Converting Access database data to SQL Server 2016.
•Moving data from Flat files to SQL Server 2016
•Provide SLAs for incident response and system availability.
•Coordinate with other State of Connecticut resource for issues resolutions, including other database administrators (DBA), system and network engineers, and application hosting group.
•Develop, design and maintain all project diagrams, data dictionary & documentation.
Environment: MS SQL Server 2005/2008/2008R2/2012/2016/2017, TSQL, SSIS, SSRS SQL Profiler, Access 2013 Microsoft Outlook, Visual studio 2010 Visual studio 2012, Team Foundation Server, Windows Enterprise Server 2008/2012, JIRA 7.0,CRUM
Employer: - Epace Technologies Inc
Client: CVS Pharmacy (Rohde Island) (Nov2014-April 2016)
Role: Sr Database Administrator (SQL DBA)
Responsibilities:
•Installation, administration, and configuration of SQL Server 2005/2008/2008R2/2012
•Maintenance and applying services pack and hot fix of 2005/2008/2000R2/2012 in Production and development.
•Administration and troubleshooting of active/active SQL 2 node cluster
•Design, develop, implement and troubleshoot backup strategies for OLTP Prod/Stage environment.
•Design and develop data dictionary
•Working along with the developers to perform database development activities.
•Strong in developing database queries, data analysis and data maintenance.
•Strong database development skills (Ad-hoc Queries, Stored Procedure, Views, triggers, functions)
•Data migrations across the environments, Dev, QA, ST and Production.
•Setup, Managing and troubleshoot mirroring and log shipping
•Setup, Managing and troubleshooting data Replication using Transaction replication.
•Identify and troubleshoot slow running query in OLTP and SSRS environment.
•Creating Data source, testing and deploying reports in SSRS environment.
•Extensively Designed, developed and maintained SSIS packages and ETL processing using various Visual Studio versions.
•Support and Troubleshoot existing SSIS package failures and performance tuning.
•Creating SQL stored procedures, views and triggers and managing indexes
Environment: Windows Enterprise Server 2003,2008 MS SQL Server 2005/2008/2008R2/2012, TSQL, SSIS,SSRS SQL Profiler,Microsoft Outlook, Microsoft Lync, Visual studio 2010 Visual studio 2012, TFS
Employer: - Epace Technologies Inc
Client: California Correctional Health Care Services (Sacramento) (Aug2013-Oct2014)
Role: Sr Database Administrator (SQL DBA)
California Correctional Health Care Services (CCHCS) is state agency which maintains the health records of the inmates. As a SQL DBA i was involved in DBA /DBD activities on time to time basis as required
Responsibilities:
•Installation, administration, and configuration of SQL Server 2005/2008/2008R2/2012
•Maintenance and applying services pack and hot fix of 2005/2008/2000R2/2012 in Production and development.
•Administration and troubleshooting of active/active SQL 2 node cluster
•Design, develop, implement and troubleshoot backup strategies for OLTP Prod/Stage environment.
•Design and develop data dictionary
•Working along with the developers to perform database development activities.
•Strong in developing database queries, data analysis and data maintenance.
•Strong database development skills (Ad-hoc Queries, Stored Procedure, Views, triggers, functions)
•Extensive using Dynamic Management Views (DMV) for troubleshooting performance issues.
•Setup alerts using SCOM monitoring tool.
•Data migrations across the environments, Dev, QA, ST and Production.
•Setup, Managing and troubleshoot mirroring and log shipping
•Setup, Managing and troubleshooting data Replication using Transaction replication.
•Identify and troubleshoot slow running query in OLTP and SSRS environment.
•Creating Data source, testing and deploying reports in SSRS environment.
•Extensively Designed, developed and maintained SSIS packages and ETL processing using various Visual Studio versions.
•Support and Troubleshoot existing SSIS package failures and performance tuning.
•Creating SQL stored procedures, views and triggers and managing indexes.
Environment: Windows Enterprise Server 2003,2008 MS SQL Server 2005/2008/2008R2/2012, TSQL, SSIS,SSRS SQL Profiler,Microsoft Outlook, Microsoft Lync, Visual studio 2010 Visual studio 2012, TFS, Jira 5.0
Employer: - Epace Technologies Inc
Client: Marsh & McLennan Companies (New Jersey) (May 2010 –July2013)
Role: Sr Database Administrator (SQL DBA)
Marsh & McLennan Companies is the premier global professional services firm providing advice and solutions in risk, and human capital. Through the market leading brands, MMC in more than 100 countries help clients identify, plan for and respond to critical business issues with risks. Marsh also involves in providing insurance policies for High Net worth Income group and Executive Benefits is a division that caters to the same needs.
Responsibilities:
•Installation, administration, and configuration of SQL Server 2005/2008/2008R2/2012
•Maintenance and applying services pack and hot fix of 2005/2008/2000R2/2012 in Production and development.
•Providing on call support 24/7 on rotational basis for production database on mission critical systems
•Implementing CR (Change Request) and CA (Change Amendments) requested by users
•Performing Root Causal Analysis (RCA) of incidents and adhering to SLA standards.
•Administration and troubleshooting of active/active SQL 4 and 2 node cluster
•Planning, Implementation and Documentation of Data Center migration of MS SQL server database due to aging hardware.
•Designing, testing and managing Backups and Recovery strategies for new datacenter.
•Setup, Managing and troubleshooting data Replication using Transaction replication.
•Setup, Managing and troubleshooting Log Shipping.
•Managing and troubleshooting Mirrored database.
•Managing SQL databases, Security creating roles, assigning roles and privileges to user.
•Identify and troubleshoot slow running query in OLTP and SSRS environment.
•Implementing SQL Standards for SQL server optimization.
•Securing SQL server and managing user accounts / logins for development purpose
•Performing In-place upgrade of database from SQL 2008 to SQL 2012 Production and development box.
•Design, deploy and unit testing of SSIS package in ETL environment.
•Troubleshoot SSIS package failures and performance tuning.
•Supporting SSIS, SSRS and SSAS environment
•Creating SQL stored procedures, views and triggers and managing indexes
Environment: Windows Enterprise Server 2003,2008 MS SQL Server 2005/2008/2008R2/2012, TSQL, SSIS,SSRS,SSAS SQL Profiler,Microsoft Outlook, Microsoft Office Communicator
Employer: - Epace Technologies Inc
Client: Verizon Business (Atlanta) (Oct 2007 –April 2010)
Role: Sr Database Administrator (SQL DBA)
Verizon is a global leader in delivering broadband and other wireless and wire line communications services to mass market, business, government and wholesale customers. Verizon Wireless operates America's most reliable wireless network, serving more than 87 million customers nationwide. My role as a SQL DBA is to provide support to the production/development/UAT database on day to day basis.
Responsibilities:
•Installation and configuration of SQL Server 2000/2005/2008 components in Development, and Production box applying Service Pack and hot fix .
•Providing on call support 24/7 on rotational basis for production database on mission critical systems
•Creation new database in production and test environment for Development and Test Environment using SQL server 2005/2008
•Administration and troubleshooting of SQL server cluster services Active/Active 4 node cluster, load balancing
•Designing, testing and managing backups and Recovery strategies.
•Setup, Managing and troubleshooting data Replication
•Managing and troubleshooting Mirrored database (Disaster Recovery)
•Managing SQL databases, Security, fine tuning of SQL queries, troubleshooting
•Worked on SQL server centralized alerts and error messaging sending to on call DBA
•Creating and managing user accounts / logins for development purpose
•Providing support to SOX auditors, providing the backups information for auditing by SOX team, performing restoration of database backup files for SOX purpose, providing trace files for the SOX audit purpose.
•Migration of database from SQL 2005 to SQL 2008 farm environment.
•Writing SSIS package to replace the existing DTS packages
•Creating SQL stored procedures, views and triggers and managing indexes
Environment: Windows 2000-Advanced server and Enterprise Server 2003, MS SQL Server 2000/2005/2008, TSQL,DTS, SSIS, SQL Profiler,PAL tool, Jmeter,yslow, opest Microsoft Outlook,IBM Lotus Sametime 7.5.1
Employer: - Epace Technologies Inc
Client: Zurich Farmers Insurance (LA) (Feb 2007–Oct2007)
Role: SQL DBA
Farmers Insurance is a leading providing insurance related financial product to cater the customer needs, as a database consultant responsible for day-to-day production operations and migration project.
Responsibilities:
•Installation and configuration of SQL Server 2000/2005 components in Development, and Production box applying Service Pack and hot fix.
•Creating various database for Development and Test Environment using sql server 2005
•Worked with Tivoli team on Monitoring and backup and integrate the alerts mechanism provided by IBM Tivoli to New SOL Server 2005 environment
•Designing, testing and managing backups and Recovery strategies.
•Managing Log Shipping for hot stand by computers
•Setup, Managing and troubleshooting data Replication
•Managing SQL databases, Security, fine tuning of SQL queries, troubleshooting
•Creating and managing user accounts / logins for development purposes
•Wrote the SSIS package to replace the existing DTS packages
•Writing SQL stored procedures, views and triggers and managing indexes
Environment: Windows 2000-Advanced server and Enterprise Server 2003, MS SQL Server 2000/2005, TSQL, Microsoft Analysis Services IBM Tivoli 6.0, Lotus notes.
Iprobe Technologies (India) (Jun2005– Jan 2007)
Role: Jr SQL DBA
Responsibilities:
Installation and configuration of SQL Server 2000 / 7.0 and SQL Client
Estimation and Monitoring Space requirements for databases and log files
Creating, copying, moving and managing databases across the servers based on project requirements
Implementing different backup schemes such as complete, differential and log
Fine tuning and optimization of SQL queries and Stored procedures using SQL Profiler, Trace and Performance monitor and ensuring indexes are using updated statistics.
Trouble shooting on network issues with TCP/IP and protocol’s and also responsible for client configurations
Source data analysis, Source and target mappings design and development
Scheduling batches and sessions, performance issues and trouble shooting
Designing, Implementing and monitoring various nightly loaders which trigger DTS packages and stored procedures and ensure that server resources such as memory, CPU and disk I/O is properly balanced.
Working with Developers to promote Product releases from development to Test to Production environment
Documenting various information on Server metrics and providing 2nd Level support to customers
Environment: SQL Server2000/7,MS Analysis Services, Windows 2000
Contact this candidate