SUMMARY

• 10 years of experience in Database Administration and Development using MSSQL/Oracle/MySQL Databases.
• Proven track record of optimizing database and application performance, ensuring data security and integrity, and implementing disaster recovery plans.
• Adept at leading cross - functional teams of developers and DBAs, providing mentorship and guidance to achieve project goals.
• Ensure backup and recoverability of all enterprise Sql Serverdatabases using Native SQL and Symantec NetBackup.
• Hands-on experience in Microsoft Azure (including SQL servers, Azure synapse analytics, Azure analysis services, Azure data factory, etc.)
• Design & implement migration strategies for systems on Azure and AWS (Lift and shift/Azure Migrate).
• Identify and troubleshoot performance issues and implement optimization strategies to ensure optimal database performance.
• Experience in creating and populating data warehouses OLTP data with various SSIS ETL packages with transformations, containers, variables, configurations and schedules. Debugging knowledge with loggers and event handlers.
• Designed, developed, tested and supported Extract, Transform and Load (ETL) processes necessary to load and validate Datawarehouse using UNIX shell scripting.
• Good understanding of the various data sources such as databases, file systems, and APIs from which data needs to be extracted.
• Develop and optimize complex T-SQL queries and stored procedures to extract, transform, and load data from multiple sources into SQL Server databases, while ensuring high performance, data accuracy, and data integrity.
• Accomplished 30% improvement in the performance of every ETL/SQL and online component, ensured apt response and data reliability by adhering to stern service level agreements.
• Expertise in multiple database platforms, including Oracle, SQL Server, and MySQL, and proficient in multiple programming languages such as Java, Python, and C#.
• Experience with PowerShell remoting for managing remote systems and performing bulk operations. Understanding of PowerShell security features such as execution policies, digital signatures, and constrained language mode.
• Familiarity with PowerShell Desired State Configuration (DSC) for declarative configuration management and infrastructure as code.
• Experience with PowerShell Core, the cross-platform version of PowerShell for Linux and macOS systems. Knowledge of PowerShell workflows for running long-running and parallel tasks.
• Created Databases on Azure Sql Server and Migrated On-Premises databases to Azure SQL.
• Configuring backups and restoring database from recovery vault.
• Create and manage databases in the cloud, using services like Azure SQL
• Skilled in database design, modeling, and architecture, with a deep understanding of data warehousing, ETL, and BI tools.
• Experience in implementing DevOps practices such as Continuous Integration, Continuous Delivery, and Continuous Deployment.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler, DTA and SQL Query Analyzer.
• Implemented Jenkins CI/CD pipelines to Orchestrate server builds in Oracle Cloud and Microsoft Azure Platforms using Terraform and Ansible.
• Worked on SQL Server Upgrade Projects from SQL Server 2005/ 2008 to SQL Server 2012, 2014, 2016, 2019 for prod and non-prod Environments.
• Experience in creating Reports of all types in SSRS like Ad-hoc Reports, Drill-Down Reports, Pivot and Tabular Reports.
• Experience in creating and populating data warehouses OLTP data with various SSIS ETL packages with transformations, containers, variables, configurations and schedules. Debugging knowledge with loggers and event handlers.
• A passionate problem-solver who thrives in challenging environments and is committed to continuous learning and .
• Delivered an automation solution using Chef by collaborating with Facets application ream to automate install of multi-tier Facets application in Oracle Cloud which helped in fast tracking builds on Oracle Cloud.
• Experienced in developing and implementing database backup and recovery plans, performing database tuning and optimization, and managing database security
• Experience in writingInfrastructure as a code(IaC) inTerraform to deploy the Azure resources and services.

TECHNICAL SKILLS

Database: Oracle 18c/12c/11g, SQL SERVER 2008/2008 R2,2012,2014,2016,2017,2019

Tools: Visual Studio, SQL Developer, Server Management Studio, PowerBI, Toad, Tableau.

Operating System: Oracle Enterprise Linux 5.x, WINDOWS 2000/2003/2008/ R2, 2012/R2, 2016,2019

Other Tools: System Center Operations Manager 2007 (SCOM), SQL Lite Speed, PUTTY, Idera SQL Safe, Idera SQL Diagnostic Manager, PROACTIVE DBA, SolarWinds DPA, SSH Tectia Client, JIRA, Confluence, Git, Azure Repo, Gitlab, GitHub

PROFESSIONAL EXPERIENCE

Confidential, MN

SENIOR SQL SERVER DEVELOPER

Responsibilities:

• Minimized downtime by optimizing and monitoring High Availability for sql server, applying log shipping, traditional failover clustering, always on clustering methods.
• Provide DB support and technical expertise for multiple applications in development, test and production SQL servers environments.
• Implemented backup strategy following company SLA; both physical and cold and logical using RMAN and DATAPUMP utilities respectively.
• Used a block change tracking which reduced backup time from 7 hours down to optimum performance.
• Set up and control user profiles and access levels for each database segment to protect essential data, creating, granting and monitoring user access rights and privileges through roles and profiles.\
• Managed database security and users in Active Directory ensure database integrity and setup maintenance plans via SQL Agent.
• Installation, configuration and update of oracle 11g, 12c, 19c using OUI, DBCA, Backup and Recovery using RMAN from 11g, 12c, 18c, 19c.
• Involved in Planning, Setup and Implementation of New Servers across the entire enterprise.
• Performed various database migrations, refreshes as per requirements.
• Managed a database migration by integrating an application database to the main CRM database designed on the contact/party role principle. As part of a team, successfully converted and migrated 170 tables, 1400 Stored Procedures, 400 scalar and table-valued functions and views to the new schema.Setup and Configure New Always-ON Availability Groups.
• Proficiency in using various DevOps tools, including source code management systems such as Git, build tools such as Maven and Gradle, and deployment tools such as Ansible and Docker.
• Installed SQL Server 2008 R2, 2012, 2014,2016,2017 & 2019 Express, Standard and Enterprise versions.
• Executed database defragmentation and reformed sql queries, improving database performance and booting speed by 75%.
• Generated 3 data warehouses using SSIS to fortify and deterge transactional data from 200 sources.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• The main technology provider used was Microsoft, utilizing technologies of Azure (Synapse analytics, analysis services, data lake, etc.)
• Maintained High Availability such as Mirroring and Log Shipping as a database disaster technique.
• Upgraded/Downgraded for various versions in sql server Prod and Non-Prod environments.
• The other teams in establishing and sharing design and development techniques for the ETL process.
• Turn over 70 plus Linux servers and virtualized environments using docker, Hyper-V and Amazon Web Services bracket (AWS).
• Scheduled jobs to call packages and stored procedures, and also create alerts for successful and unsuccessful completion of schedule jobs, performance tune ETL processes.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Design ETL processes that extract data from the sources, transform it into a suitable format, and load it into the target systems.
• Create ETL jobs using ETL tools like Talend, Informatica, and DataStage, or programming languages like Python, Java, and SQL.
• Implemented Data pump, conventional Export/Import(Oracle 11g, 12c) for migration and logical backup of database.
• Performed Lift-and-Shift to build a robust migration platform to migrate infrastructure/applications from on-prem to Azure Cloud using Azure Migrate and ASR.
• Proficient in using PowerShell to automate tasks and streamline processes.
• Experience with PowerShell scripting for system administration tasks, such as creating and managing user accounts, configuring network settings, and managing services.
• Proactively monitor resources and applications using AWS Cloud watch including creating alarms to monitor metrics such as EBS, EC2, ELB, S3, RDS, SNS and configured notifications for the alarms generated based on events defined.
• Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target Datawarehouse.
• Solved issues related to server performance and disk space.
• Installed different security patches, cumulative updates, service packs and hot fixes in both pre-production environment (PPE) and production environment.
• Integrated Maven, Jenkins for the builds as the Continuous Integration process.
• Written documentation for all the Database maintenance related issues.
• Supported 24*7 production support and solved all kinds of critical problems.
• Used Idera Monitoring tool & SolarWinds DPA to collect statistical data to help narrow down performance issue.

Confidential, Madison, WI

Role: SQL SERVER DEVELOPER(SSIS/SSRS)

Responsibilities:

• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Designed Database modeling using MS Visio (VSS).
• Solved issues related to server performance and disk space.
• Installed different security patches, cumulative updates, service packs and hot fixes in both pre-production environment (PPE) and production environment.
• Resolve database performance issues, database capacity issues and other distributed data issues (OLTP).
• Designed Database modeling using Erwin.
• Familiarity with PowerShell cmdlets and modules for managing Microsoft technologies such as Active Directory, Exchange Server, and SharePoint.
• Migrated databases from SQL server 2000 to SQL server 2005 and running stored procedures to make sure nothing is broken after migration.
• Testing ETL jobs for accuracy, completeness, and performance. ETL developers also troubleshoot and debug issues in the ETL jobs.
• Monitor ETL jobs and maintain them by updating them when data sources or target systems change, or when new business requirements arise.
• Document the ETL processes, including job design, configurations, and mappings, for future .
• Closely with data analysts and data scientists to ensure that the data meets the business requirements and is suitable for analysis. Ensure the security of the data by adhering to the data privacy and security policies of the organization.
• Knowledge of PowerShell Integrated Scripting Environment (ISE) and Visual Studio Code for writing, testing, and debugging PowerShell scripts.
• Ability to use PowerShell to gather system information and generate reports for troubleshooting and auditing purposes.
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Used DDL and DML for writing triggers, functions, stored procedures and data manipulation.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Created data queries and reports using Well View, QlikView, Visual Studio, SQL Server Management Studio, SSRS, and Excel. Created custom queries/reports designed for quality verification and information sharing.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Used datasets and ADO.Net to retrieve data from the databases.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.

Confidential, Farmers Branch, TX

Role: SQL SERVER DEVELOPER/DBA

Responsibilities:

• Maintained High Availability such as Log Shipping and Mirroring as a database disaster technique.
• Involved in ensuring data recovery, maintenance, data integrity and space requirements for physical database.
• Formulated 800+ ETL packages using SSIS and converted data from Oracle sources to MS SQL.
• Devised 10 onsite databases and sustained 20 databases, thereby decreasing production cost by 12% and heightening productivity using data modeling techniques.
• Created OLAP cubes, facts and dimensions for the analysis of sales in different locations and process data from data mart using SSAS.
• Developed dashboard reports using Reporting - Services, Report Model using Report Builder.
• Migrated packages from development server to production server using package configuration.
• Improved Performance of the database by creating clustered and non-clustered indexes and by optimizing the T-SQL statements using SQL profiler.
• Scheduled jobs to call packages and stored procedures, and also create alerts for successful and unsuccessful completion of schedule jobs, performance tune ETL processes.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Implemented backups (hot amp; cold back-ups) along with disaster recovery, exporting / importing databases, monitoring procedures and ongoing support.
• Optimized the T-SQL query performance with modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.
• Ensuring that the Azure Data Lake environment is secure, in compliance with regulatory requirements, and adheres to industry best practices for data protection, including access control, data encryption, and data masking.
• Monitoring data processing workflows and identifying issues, and providing technical support to end-users.
• Developing and maintaining automation and scripting tools to streamline data management and processing tasks, such as data backups, data cloning, and data migration created 40 plus net websites with 100% client containment and on time finalization, three weeks on the job.
• Solved issues related to server performance and disk space.
• Installed different security patches, cumulative updates, service packs and hot fixes in both pre-production environment (PPE) and production environment.
• Resolve database performance issues, database capacity issues and other distributed data issues (OLTP).
• Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and mapplets designer using Informatica PowerCenter.
• Configured plug-ins for the integration tool to the version control tool.
• Supported 24*7 production support and solved all kinds of critical problems.
• Successfully implemented database mirroring in 2005/2008 Environment.
• Used profiler to get better understanding on current performance issues.
• Created job schedules to automate the routine tasks.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Installation, Administration, Backup & Restore Procedures, Database Security, SQL Database Development and Access database upgrades across the enterprise.
• Create new databases, tables, and fields for data entry, performing database capacity planning.

Environment: Windows 2000, Windows 2003, UNIX, SQL Developer, OEM, SQL*LOADER, SQLServer2005, 2008, 2008R2.

Confidential

Role: SQL Server Developer

Responsibilities:

• Installing new versions of database software and perform maintenance functions of the database.
• Created indexes to improve the system performance.
• Find internal websites for agents and management, saving an average of $8K in labor cost weekly.
• Rebuilding indexes at regular intervals for better performance in large datasets.
• Analyzed performance bottlenecks and provide appropriate solutions.
• ETL creating ETL metadata reports using SSRS, reports including execution times for the SSIS packages, failure reports with error description.
• Developed stored procedures that increased productivity by automating repetitive tasks. implemented data security measures that prevented sensitive information from being compromised.
• Created job schedules to automate the routine tasks.
• Scheduled jobs to call packages and stored procedures, and also create alerts for successful and unsuccessful completion of schedule jobs, performance tune ETL processes.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Design ETL processes that extract data from the sources, transform it into a suitable format, and load it into the target systems.
• Create ETL jobs using ETL tools like Talend, Informatica, and DataStage, or programming languages like Python, Java, and SQL.
• Implemented Data pump, conventional Export/Import(Oracle 11g, 12c) for migration and logical backup of database.
• Performed Lift-and-Shift to build a robust migration platform to migrate infrastructure/applications from on-prem to Azure Cloud using Azure Migrate and ASR.
• Generated report using Microsoft report analyzer.
• Created both Tabular, Matrix, drill down reports using SSRS 2005.
• Created reports by using bar chart, pie chart to analyze critical data in SSRS 2005.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Interface with Tech Support for information gathering, trouble-shooting, and general technical support for security patches, installs, upgrades, etc.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Installation, Administration, Backup & Restore Procedures, Database Security, SQL Database Development and Access database upgrades across the enterprise.
• Synchronized different environments such as Developer, testing, Pre-production and production.

Environment: T-SQL, SQLServer2000, 2005 OLAP, DB2, ETL, TCP/IP, SAN, DTS, SSIS, Microsoft report analyzer, windows 2000, 2003, IIS, XML, Web store.