We provide IT Staff Augmentation Services!

Database Analyst Resume

Chandler, AZ

SUMMARY:

  • 10+ years of IT experience as SQL Server and Oracle DBA i n Production, Development, and Data Warehouse Environments (OLTP and OLAP) across versions.
  • Expertise with Design, Implementation and monitoring of production servers with Installing, Patching, Upgrading, Configuration, Performance Tuning, SQL server Always ON in High Availability and Disaster Recovery mode in Hybrid/Other AO types includes Option 1, Option2, Option 3 and Option4.
  • Experience Migrating SQL Server implementations from On - Premise to Microsoft cloud (azure) (IaaS) and Amazon cloud (AWS) environment for various business-critical applications.
  • Expertise in Design, implementation and monitoring of Clustering(Active-Passive and Active-Active), Log shipping, Mirroring(High Safety and High performance) and Replication(Snapshot & Transactional) on various environments including configuration of WSFC clusters,Quorum and FSW on multi subnet.
  • Perform Oracle database administration tasks include configuration management, backup/recovery, performance optimization, and space management
  • Perform database deployments and provide support for application releases
  • Understand software development initiatives and plan related database changes
  • Cross-train and instruct other DBAs on specialized skills/
  • Experience performing In-Place and Side-by-Side upgrades (Migration) across multiple SQL server versions (2017/ 2016/ 2014/2012/2008 R 2/2008/2005/2000 ). Handled Large DB’s in Clustered environment using physical storage configuration and SAN Optimization with different RAID Levels.
  • Excellent experience in RDBMS concepts and constructs along with Database Objects creation and debugging such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers. Optimizing code and improve efficiency.
  • Extensive Experience in Installation, Configuration and Administration for SQL Server in Confidential Clustered and Non-Clustered environments.
  • Planning Backup strategies,Maintenance plans,Restore,Recovery,Updating Statistics,Rebuilding and Reorganizing Indexces, Defragging Tables,Replication,Linked Serveres using native/Third-party tools (Lite Speed, Fog light,Red Gate SQL Backup and Splunk).
  • Extensive experience in defining and controlling User Privileges, Logins, monitoring S ecurity and Confidential udit issues. Monitored Event Viewer,SQL Error Logs,and log files for S/W and H/W Errors.
  • Experience solving database issues with Index fragmentation, Integrity checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling and encrypt SQL data bases using various encryption processes.
  • Expertise in Performance tuning, Optimization, Data integrity and Statistics by using Idera Diagnostic Manager, Fog light and SQL Profiler, PerfMon, DB Engine Tuning Advisor, Extended events, Auditing.
  • Experience in analyzing SQL wait types, execution plans for troubleshooting performance issues. Managed Stored Procedures, jobs,and utilize serever side tracing to identify performance issues with deadlocks & other locking issues. Knowledge in using DMVs and DMFs in finding and solving Performance issues.
  • Experience in Installation, configuration, Monitoring and administering OLAP database Warehouses Using Integration (SSIS), Reporting (SSRS) & Analysis services (SSAS). Hands on experience in Batch Process,Import,Export, Backup,BCP, DTS and SSIS.
  • Experienced in using SSRS to build Sub-Reports, Drilldown reports, Drill Through reports, Parameterized reports and Map reports based on relational or dimensional sources with Data visualizations like KPI, gauges, charts and matrixes, with toggle feature, all of which can be delivered on-demand or configured to be deployed according to schedule.
  • Experience in building robust Architecture to organize Data flow from various homogeneous and heterogeneous system using SQL Server Integration Services (SSIS) and Data Transform Services (DTS).
  • Good T-SQL Developer skills including stored procedures, Indexed views, Ad hoc queries, User Defined Functions, Triggers, and Distributed Queries.
  • Implemented Team Foundation Server TFS as Version Management for Microsoft Technologies.
  • Expert in Design and development of ETL Packages using SSIS (SQL Server Integration Services) for integrating data from heterogeneous sources like Excel, CSV, flat file,Oracle to MS SQL server, Text Format Data.
  • Provide extended support for business-critical applications like SharePoint, Project Financial Data hub and SCOM.
  • Created Custom Reports for Visual Studio Team Foundation Server 2008,2010 and 2012.
  • Effective communication and team management skills working on projects involving 24/7 Production Support to cover production/other critical issues and deployments.

TECHNICAL SKILLS:

Databases: SQL SERVER 2017,2016, 2014/2012/2008 R 2/2008/2005/2000 , MySQL,MS-Access, DB2, Oracle Database 10g/11g/12c,MangoDB, Casandra.Bigdata.

Operating Systems: Windows Server 2003 / Server 2008 / Server 2008R2/ Server 2012, Server 2012R2, Unix, Linux.

Programming Languages: TSQL, PL/SQL, Power Shell, C, C#, VBScript, HTML, XML

SQL Tools: SQL Server Management Studio, SQL Navigator, Microsoft Visual Studio 2008/2010/2012 , SQL Server Enterprise Manager, BIDS, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerfMon, SQL Configuration Manager, IIS.

Cloud Environments: Amazon Web Services (AWS), Microsoft Cloud(Azure)

Third Party Tools: Lite speed,Erwin,Red gate,Fog lite, Spot Light,splunck, Idera Diagnostic Manager, Autosys.

PROFESSIONAL EXPERIENCE:

Database Analyst

Confidential, Chandler, AZ

Responsibilities:

  • Involved in Planning for Upgrades and migration of major applications from SQL Server and MySQL 2014 to SQL Server 2017 and from SQL Server . Maintained and Supported large DB’s around 15 TB for each DB.
  • Experiense on installing,configuring,manging and monitoring of all SQL server with service packs, Cumulative updates and hot fixes.Involved in physical and logical design and schemas for databases of new application.
  • Designed, implemented and maintained the SQL Always ON for the 2017/2014 versions and Implemented.
  • Worked on Data Extraction, Transformation and Loading from different data sources using ETL tool like SSIS as per client requirements. Creating the ispac files and deploying the SSIS projects and creating the configurations for the projects and run those projects through SQL agent jobs. Use Autosys tool to run the batch jobs. Monitor and troubleshoot ETL,BCP,SSIS and application jobs and other tools.
  • Install SQL clusters in Active/Active and Active/Passive Topology.Remote monitoring of SQL server 2012,2014 and 2017.
  • 24*7 production Database On Call support. Providing support for the clustered and Non-Clustered SQL Server 2014/2012 instances in Production, Development and UAT environments.
  • Planning the backup strategies, Maintenance plans using Native & Third-party tools (Lite Speed SQL Backup) and automated Backup and restore through Lite Speed SQL and shell scripting.
  • Encrypt SQL data bases by using Microsoft Transparent Data Encryption (TDE). Experience with analytics platforms and other business intelligence tools((Tableau, Power BI).
  • Actively worked on performance tuning by analyzing the Windows, SQL, Memory and Query optimization by using the Spot light, Fog light Tools and T-SQL debugging and actively worked on capacity planning, submitted the best plans to customer for successful implementation.
  • Active focus on all critical tickets which are created in pac2000/ Service Management Ticketing System to resolve them with in SLAs and providing the RCA for the critical issues. Monitoring the incident queue to provide Confidential quick resolution.
  • Checking the Server roles and health during failover in clustering and mirroring and implementing the SQL server 2012 transaction replication and working on the alerts/issues
  • Migrated the SQL Servers from on premise to Microsoft azure (IaaS) and Amazon cloud (AWS) environment for the business-critical applications and working on the all alerts with in minimal time.
  • Good experience With Windows Azure Cloud Administration which includes services like: EC2, S3, EBS, VPC, ELB, AMI, SNS, RDS, IAM, Route53,Autoscaling, Cloud Front, Cloud Watch, Cloud Trail, Cloud Formation, LAMBDA,OPS Work, Security Groups.
  • Worked on TFS servers for the .NET code/SSIS package/project documents check in and fixed the issues and migrating applications from Quick base to .NET based SQL server 2014.
  • Enabled the Server and DB level audit to all the critical production DB’s for tracking all the DML and DDL changes.
  • Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used 3rd party tools(Spot Light and Fog light) for performing root cause analysis.
  • Configured the Cluster as part of all AO configurations and applied the monthly patches and service packs to achieve the security and performance metrics.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Technical Analysis, Code Review, Implementation, and production support
  • Developed Power Shell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.

Lead DBA Consultant

Confidential, NYC, NY

Responsibilities:

  • Involved in Planning for Upgrades and migration of major applications from SQL Server and MySQL 2008 to SQL Server 2012 and from SQL Server and 2016.
  • Designed, implemented and maintained the SQL Always ON for the 2014/2012 versions and Implemented the Hybrid AO & other AO types includes option1, option2, option3 and option4.
  • Worked on Data Extraction, Transformation and Loading from different data sources using ETL tool like SSIS as per client requirements.
  • Perform Oracle database performance analysis and optimization, define bottlenecks and manage testing and production implementation
  • Make recommendations for process improvements
  • Create and execute scripts
  • Perform Root Cause analysis
  • Perform deep impact analysis of problems, projects or technical solutions
  • Closely cooperate with vendors and external service providers
  • Develop and implement processes
  • Performance Tuning daily for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
  • Extensive experience in T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) creating Design, Development, Testing, Implementation and Production/Support phases of SDLC for Data Warehouse, Client/Server, RDBMS and Web Based Application working in Agile, Waterfall.
  • Migrated the SQL Servers from on premise to Microsoft azure (IaaS) and Amazon cloud (AWS) environment for the business-critical applications and working on the all alerts with in minimal time.
  • Planning the backup strategies, Maintenance plans using Native & Third-party tools (Red Gate SQL Backup and Lite Speed) and automated Backup and restore through shell scripting.
  • Tune the performance, Optimization, Data integrity and Statistics by using Idera Diagnostic Manager, Fog light SQL Profiler, PerfMon, DB Engine Tuning Advisor, Extended events, Auditing.
  • Worked on SQL Server 2014/2012/2008 R2/2008 maintenance activities including working on the SQL server/Application performance issues.
  • Planning Backup strategies and Maintenance plans using native/Third-party tools (Lite Speed, Fog light SQL Backup and Splunk).
  • Good experience With Windows Azure Cloud Administration which includes services like: EC2, S3, EBS, VPC, ELB, AMI, SNS, RDS, IAM, Route53,Autoscaling, Cloud Front, Cloud Watch, Cloud Trail, Cloud Formation, LAMBDA,OPS Work, Security Groups.
  • Deployments and involved in working for Confidential high scalability and high availability environment running Linux.
  • Ensure data integrity and data security on Azure technology by implementing Azure best practices. Ability to identify and gather requirements to define Confidential solution to be build and operated on Azure.
  • Managed servers on the Windows cloud (Azure) platform instances using Puppet, Chef Configuration management.
  • Checking the Server roles and health during failover in clustering and mirroring and implementing the SQL server 2012 transaction replication and working on the alerts/issues. Encrypt SQL data bases by using Microsoft Transparent Data Encryption (TDE).
  • Use of Service Now ticketing system, process and procedures and ensuring that the tickets are addressed within the SLAs and Monitoring the incident queue to provide Confidential quick resolution
  • Worked on TFS servers for the .NET code/SSIS package/project documents check in and fixed the issues and migrating applications from Quick base to .NET based SQL server 2012.
  • Worked on developing the SQL stored procedures and tuning them and implementing the stage environment with the appropriate table modeling.
  • Developed the application flow diagrams, worked on the poor design section with respect to data base/application.

Lead DBA Consultant

Confidential, Atlanta, GA

Responsibilities:

  • Designed, implemented and maintained the SQL Always ON for the 2014/2012 versions and quick analysis and fixed the AO listener connectivity issues, listener recreation/swapping and IP mappings / changes.
  • Migrated the SQL Servers from on premise to Microsoft azure (IaaS) and Amazon Web Services Cloud (AWS) migration for the business-critical applications.
  • Migrated SSIS packages to higher versions and fixing the issues. Developed and Deployed the SSIS packages to extract date from Flat files, Excel, Oracle, and DB2 and worked on Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
  • Implemented the Hybrid AO and helped the business teams with appropriate migration planning and involved in working for Confidential high scalability and high availability environment running Linux.
  • Configured the multi subnet WSFC Cluster, Quorum and FSW as part of all AO configurations and applied the monthly patches and service packs to achieve the security and performance metrics.
  • Implemented the SQL Server Mirroring, Snapshot, Transactional and Merge replication on versions 2014/2012/2008 R2/2008/2005 for various application based on the business requirements and sorting the issue very quickly includes latency, PK violation, Job failures and Ad hoc issues.
  • Work with development teams and 3rd party vendors throughout the development life cycle regarding optimal use of database resources and features
  • Monitor and analyze database performance and make changes to optimize performance
  • Assist in database performance tuning
  • Responsible for working with the development/support teams to optimize SQL statements
  • Follow release management, change management and quality assurance standards
  • Perform database space management and monitoring
  • Assist with migration and/or load of application data into the database environment
  • Designed and Implemented the Hybrid SQL Always On for various servers and performed the post checks, fail over and fail back testing and configured the alert systems for all HA and DR implementations which helps in monitor the status, changes and performance.
  • Actively worked on performance tuning by analyzing the Windows, SQL, Memory and Query optimization by using the T-SQL debugging and actively worked on capacity planning, submitted the best plans to customer for successful implementation.
  • Active focus on all critical tickets which are created in Remedy tool/ITSM to resolve them with in time and providing the RCA for the critical issues.
  • Extensively worked on Profiler, perfmon, SQL traces, DMV’s, extended events and auditing and managed the SQL Server and database securable by providing the appropriate access to objects.
  • Developed Power Shell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
  • Designed and Deployed SSRS reports, Scheduled reports to run on daily basis to send e-mails.

Consultant SQL DBA

Confidential, Glendale, CA

Responsibilities:

  • Installed SQL Server 2012 and configured Always On with primary and secondary replicas, Read-Only databases, listener and with Application Intent.
  • Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used SQL Profiler for optimizing stored procedures
  • Installed SQL Server 2012/2008R2 on windows server 2012 and migrated SSIS packages and databases from SQL Server 2005/2008/2008 R2 to SQL Server 2012.
  • Implemented SQL mirroring, Clustering, Transactional replication and Merge replication and regular checks that include alerts, jobs failures, latency, and performance and fixing the issues.
  • Experience with analyzing query plans, writing stored procedures, try-catch blocks, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks and blocking, Checking the threshold values and baselines.
  • Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • Create triggers to keep track of changes to the fields of tables when changes are made and monitored and modified Performance using execution plans with query hints and Index tuning.
  • Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
  • Used SSRS to create reports that draw content from Confidential variety of data sources.
  • Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
  • Created SSIS/DTS packages for Finance application that would transfer data among servers to perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks and incremental loading of dimensions, facts, error handling in SSIS.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Senior SQL DBA

Confidential, Houston, TX

Responsibilities:

  • Installation and configuration of SQL Server 2000/ 2005/2008/2008 R2 and design, develop and maintain database administration tasks for administering all versions of SQL Server.
  • Worked on SQL server up gradation from SQL Server 2000 to SQL Server 2005/2008 and designed and developed DTS packages and Migrated DTS packages from SQL 2000 to SQL 2005.
  • Worked on ETL migration with required transformations like Derived Column, Data Conversions, Sort and Union.
  • Designed, Configured and automated SSIS packages as per Business (LOB) requirement and hands on experience in IIS 6.0/7.0/7.5.
  • Create and maintain various databases for development, testing, staging and production environments using SQL Server 2005/2008.
  • Configured and maintained SQL Server Log shipping, Replication and Mirroring and Monitoring and Troubleshooting SQL 2008 Cluster.
  • Written Stored Procedures, Functions, and Views as per DBA requirement and troubleshooting query performance.
  • Manage users including creation/alteration, grant System/DB roles and permissions on DB objects.
  • Create and schedule maintenance plans, developed successful Backup strategies based on recovery models.
  • Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
  • Installed and worked on F-Secure SSH Server, generating keys and exchanging with other teams to establish the connectivity for file transfer on daily basis.

Hire Now