We provide IT Staff Augmentation Services!

Etl Dba Resume

SUMMARY

  • Around 9 years of experience in Administration using MS SQL server 2005/2008/2008 R 2/2012/2014/2016/2017 and Oracle systems in Azure and AWS OLTP and OLAP environment.
  • Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
  • Worked on setting up Jenkins for deployments over lower environments like UAT’s, Stage, Qa and Dev machines
  • Implemented side by side and In place Migration (Data center) of MS SQL server 2005 to 2008R 2/2012/2014/2016 and applied Patches and Service packs to update different versions of MS SQL server.
  • Developing functional process diagrams for IBM DB2, POSTGRES, ORACLE database services
  • Proficient in SQL server 2008 features like Data compression, Resource Governor, Backup Compression, Mail setup, Jobs, Alerts and Database Tuning Advisor.
  • Experience in implementing and setting up DR Disaster Recovery and HA High availability solutions like different Clustering (Active - Active) and Replication
  • Experience in regular maintenance activities like Query Tuning, statistics update, Index rebuild, log file monitoring, temp DB monitoring, handling blocking, deadlock resolutions, and fragmentation issues.
  • Explicitly used third party tools like Netapp, Lite speed and SQL sentry
  • Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
  • Implemented Data center migration with cross platform implementation on AWS EC2 instance using DMS.
  • Hands on experience in implementing Managed Service Accounts MSA’s on SQL services.
  • Good Knowledge on using Power shell commands for Server performance.
  • Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
  • Experienced with deployments, Maintenance and troubleshooting applications on Microsoft Cloud infrastructure Azure and Snowflake Cloud Data platform.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and Windows logs for hardware related errors.
  • Experience in Network TCP IP, SSL and Firewall trouble shooting issues.
  • Experience in documenting the Root Cause Analysis for various issues like memory and outage of database and related hardware failure.
  • Knowledge on IBM DB2, Postgres SQL data warehousing concepts using Linux\Unix.
  • Auditing of database for user’s transaction, login, database action and removing orphan users.
  • Cleared Payer HIPPA certification for PHI related compliance.
  • Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, SnowFlake Cloud, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Data Bricks, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
  • Extensively used Repositories like Team Foundation Server (TFS) and Clear Case for Data Archival.
  • Handled numerous Change Management requests on production servers.
  • 24 X 7 Production Database on Call Support.
  • Flexible, Enthusiastic and project oriented team player with excellent communication skills and analytical skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Operating Systems: Azure Cloud, VM, MDOS, Windows, Tomcat, NT/ 2008/2010/2012 R2/2016/2019

Databases: MS SQL Server 2017/2016/2014/2012/2008 , Oracle R 2/2008/2005/2000 , MS Office, Access 97/2000/2003

ETL and REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data transformation services (DTS), SMTP server services

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, perfmon counters

Third Part Tools: Jenkins, Bamboo, Boomi, Spotfire, Lite speed, Nagios, Fog lite, Red gate, Web services, SQL sentry, DbAmp.

Languages: T-SQL, SAS, XML, Python, HTML, XHTML, Power Shell, Linux & Unix.

PROFESSIONAL EXPERIENCE

Confidential

ETL DBA

Responsibilities:

  • Migrating Datacenter and SQL Databases from Big Data, Sql server 2008R2 to Sql server 2014\2016 on Azure Platform using RDS.
  • Experience working with SnowFlake Cloud Performance Metrics and Plan Management.
  • Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
  • Analyzing long running slow queries and fine tune the same to optimize application and system performance.
  • Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.
  • Migrating into Oracle and Salesforce for flexible, cost- effective, reliable, scalable, high-performance and security using DBAmp
  • Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running PL\SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
  • Fixed issues in network level of RDBMS like TCP IP, SSL and CertAuth.
  • Experience in identifying root cause analysis and fixing the Tomcat, Windows/IIS Web Server/FTP Related issues.
  • Experience designing and optimizing high-performance databases
  • 1+ year(s) cloud (Azure & Snowflake) DBA experience.
  • Ability to create dynamic views from Databricks & Snowflake
  • Extensively worked on Transparent Data Encryption (TDE) and Auditing
  • Performance tuning of databases by windows performance monitor and SQL Profiler.
  • Worked on Data modelling using Erwin tool using Cassandra, Hadoop Big data.
  • Used Index tuning wizard to redesign and created the indexes for better performance

Confidential

Azure SQL DBA

Responsibilities:

  • Integrated Subversion and SQL agent jobs with Jenkins to implement the continuous integration\daily operational process.
  • Migrating Databases from Oracle and SQL 2008R2 to Azure Sql server 2016\2017.
  • Provide 24*7 Application availability using Auto scaling Services, including configuring, defining and testing auto scaling policies and created alarms to call scale up/down policy.
  • Installed Distributed Availability groups for Better HA and DR.
  • Analyzing long running slow queries and fine tune the same to optimize application and system performance.
  • Deploy, monitor and manage applications in Azure cloud using Team foundation server (TFS) into Development, Test and Production web and application server environment.
  • Used Azure Databricks for daily BI support and Analytics purposes.
  • Worked on Data modelling concepts using Erwin tool using Oracle 11G, Postgres, DB2, Hadoop Big data.
  • Migrating into Azure Managed Instances on cloud for flexible, cost- effective, reliable, scalable, high-performance and AD Group security
  • Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
  • Automating backups using Powershell scripts to transfer data in DR bucket.
  • Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
  • Creating alarms in Cloud and production environments watch service for monitoring server’s performance, CPU Utilization, disk usage etc.
  • Identified and resolved database PTO performance tuning and Optimization issues, database capacity issues and other distributed data issues.
  • Experience in working on source controller tools like TFS, CVS, IBM Clear case, and GIT.
  • Experience in installing, configuring and deploying Jenkins .
  • Experience building infrastructure as code.
  • Creating scripts that generate reports to proactively monitor the environment
  • Migrating Payer databases to datacenters to Azure(cloud) and DataBricks, while maintaining them on daily activity basis
  • Designed User Defined Routes with custom route tables for specific cases to force tunneling to the Internet via on-premise network and control use of virtual appliances in the customer’s Azure environment.
  • Designed Databases for data integrity and queries execution efficiency applying knowledge of SQL Server 2017 and Azure Databricks
  • Creation of cloud formation Templates of existing environments to use in building similar environments in the same or different regions for HA High Availability
  • Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
  • Experience in IaaS and PaaS in a hybrid cloud environment working with private and public cloud service providers
  • Created a discussion group for cloud support team in shared point and maintained all documentations in SharePoint.
  • Key member of a Managed Services team that installs, configures and maintains Software, Databases and Web applications .
  • Experience working with Agile/Scrum environment.

Confidential

Database Administrator

Responsibilities:

  • Installed and Upgraded from Sql Server 2008 to Sql server 2014 & 2016 on various Production Servers R2 and upgraded to their respective Service Packs & cumulative upgrades.
  • Implemented Sql Data Compression using Sql server 2008 for compressing data and Log Files, Back Up Level.
  • Installed SQL Server 2014 HADR Failover cluster.
  • Oracle PLSQL standalone and RAC clustered (11g, 12c) database environments.
  • Worked on Cross Database Platform Migrations from SQL to IBM DB2 and Oracle 11g.
  • Migrating Databases from Sql server 2008 to Sql server 2014\2016.
  • Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
  • Extensive experience with clinical (Patient, Pay) data
  • Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
  • Identified and resolved database performance issues, database capacity issues and other distributed data issues.
  • Experience in ETL Migrating Assistant DTS 2000 packages to SSIS packages in 2005 using Migration Wizard and Kafka.
  • Analyzing long running slow queries and fine tune the same to optimize application and system performance.
  • Used Power BI, IBM DB2 using Unix for data warehousing concepts
  • Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
  • Used Tableau for presenting front end data and represent the backend data visualization.
  • Solving Tickets on Daily Basis for Cassandra OLTP Production Issues.
  • Performed Backups, restores of databases using Lite Speed tool.
  • Checking Payer Database Health by using DBCC Commands.
  • Supporting production team & developers while being On Call DBA.

Confidential

Sr Database Admin

Responsibilities:

  • Managed and administered SQL server 2005\2008\R2\2012 servers
  • Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012
  • Configured Windows Fail Over Clustering and SQL Clustering on Multi Subnet Cluster
  • Migrating Databases from SQL Server 2008R2 to Teradata and Netezza DB systems.
  • Worked on good standard Python, T-SQL queries by using different store procedures, Triggers, Indexes, Views.
  • Configured Active Directory to create users and login groups to access failover clustering
  • Deployment of databases, jobs from pre-production to production
  • Performed installations of SQL 2005\2008\2012\2014 on clustered and standalone servers
  • Worked on moving SQL databases to DR location on Azure Cloud.
  • Upgradations of sql server versions and applying patches and hot fixes
  • Adding nodes to already existing clustered servers as a part of data load\High availability
  • Configured DR Transactional Replication and Log Shipping with SQL Server Management
  • Implementation of SQL server logins, Roles and Authentication modes as a part of AD security policies
  • Configured SnowFlake Databases with Database mail, linked servers.
  • Extensively worked on Transparent Data Encryption (TDE) and Auditing
  • Performance tuning of databases by windows performance monitor and SQL Profiler
  • Used Index tuning wizard to redesign and created the indexes for better performance
  • Fine-tune Stored Procedures using Execution Plan in T-SQL for better performance.
  • Write T-SQL Scripts for database backup jobs and daily/weekly jobs
  • Tune slow running queries using SQL Server Profiler for PTO issues
  • Worked with database tuning advisor, SQL server profiler, Performance counters and activity monitor for Performance tuning
  • Used DBCC and DMV commands for day-to-day troubleshooting tasks
  • Import data across multiple instances using BULK INSERT and BCP Utility
  • Involved in Capacity Planning, Database Normalization and De-normalization process
  • Optimize the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application
  • Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.

Hire Now