Project Management Sql Server

Anuj Gupta Sr. DBA & Cloud DB Migration Specialist

Email **********@*****.*** https://www.linkedin.com/in/anujdba Mobile +1-732-***-****

Summary

Experienced in Migration on Cloud Databases for Amazon AWS Aurora PostgreSQL,Redshift,MySQL,QuasarDB, SQL AZURE, SQL Server, Oracle, IBM DB2 to SQL Server, NoSQL, Epicor ERP Database Migration & Administration based on Project and management.

●A competent professional with more than 24 years of experience in handling Multiple Database platforms including the Migration of Databases along with Database Engineering, Administration & Architecture for top public sector clients such as Georgia-Pacific, State of Ohio, Gwinnett County (GC), Fulton County (FC), Louisiana Department of Education (LDOE), COMC game sports comics collections Marketplace, Zelis HealthCare, Uniguest.

●Top clients which include Morgan Stanley, Verizon, Cox Automotive, TMX-Finance, Yardi and other international clients that include Emirate NBD Banking, Deloitte, Dubai Municipality on Project Management for Database Architecture using SDLC with MS Database Certified & PRINCE2® Registered Practitioner Certificate in Project Management and handling Production activities related with databases and handling DBAs for delivery of project.

●15 Years of experience in Leading and managing teams for up to 8 members.

●Project Management for Database Architecture using SDLC with MS Database Certified & PRINCE2 Registered Practitioner Certificate in Project Management and handling Production activities related with databases.

●Managed to migrate to NoSQL databases based on project to cloud environment using MS Azure SQL Managed Instance Azure Data Factory and AMAZON AWS migration to cloud database environment.

Technical Skills

Database: SQL Server 6.5 to 2022, Azure SQL IAAS PAAS SQL Managed Instance Azure SQL, DB2,

Oracle, AWS Aurora PostgreSQL 9/9.1/10, AWS Redshift, MongoDB, MYSQL on AWS, SQL Server on AWS, Amazon AWS EC2 SQL Server,QuasarDB on AWS EC2 Instance, Neo4J, Timeseries, MongoDB DocumentDB

Database Tools: AWS Schema Conversion Tool, Enterprise Manager, SQL profiler,AWS Glue, Gen AI,

SSDT, BI Tool, ADF (Azure Data Factory), Azure Data Lake, Data Analytic, Power BI, SSIS, SSAS,

DW, Erwin Data Model, DBArtisan, SSMA, DBeaver,PGAdmin, MySQL Workbench,MongoDB Compass

Reporting tools: SSRS, Crystal Reports and Microsoft Reporting Server

SQL server Tools: SQL profiler, Microsoft Reporting Server, MS Visio, and XML, LightSpeed

Application Tools: Light Speed, Idera Redgate, Quest Fog Light, NetBackup, Scrum Master Rally Tool, Jira

Monitoring Tools & OS: AWS CloudWatch, Derdack Enterprise, SCSM, LANDesk, Fog Light BMC, IDERA SQL DM, SolarWinds, SQL Sentry, Spotlight., Data Dog, Windows 2024 to 95, DOS/ Unix/ Solaris/AIX /RedHat Linux,Mobaxterm,Putty,VNC

Method & Tech: Prince2, Agile, Waterfall, Kanban, Jira, Enterprise App management/Tablet/Mobile Apps

Languages: Visual FoxPro, Visual Basic, PowerBuilder, C++, C, T-SQL, SQL

Framework: MS.NET

Middleware: Web Services

Client/Server Tools: VB, Sybase PowerBuilder, MS.Net

Web Tools: ASP.net, HTML, IIS

Other Tools: HA, VMware, IDERA SQL DM, Lotus Notes, VSS/TFS, JIRA, Rally, Accountmate, Epicor, Delphix

Education / Credentials

AWS,Azure, MySQL & Quasar Databases Product Vendor Trained

Advance Diploma in Networking and Communication

MCDBASQLServer2000EXAMNo:070-229

MS SQL SERVER Always on Availability Groups and FCI – Monitoring & Troubleshooting

MCP/MCSAWindows2003ServerEXAMNo:070-290

CCNA Certification

Bachelor of Arts (English, Sociology) (Lucknow University)

PRINCE2 Practitioner & Foundation Certificate in Project Management

Work Experiences

Georgia-Pacific July 2024 – Till Date

DBA & DB Migration Lead Atlanta, GA

●Upgraded, migrated, managed fine-tuned and database administration of analytic databases such as AWS Redgate, PostgreSQL, MySQL, QuasarDB Database on various versions for Dev QA UAT and Production database environments.

●Enabled and finetuned set work_mem to appropriate sizing for performance tuning at postgresql database servers.

●Created user’s roles and permission for AWS and SQL database servers and enabled DB encryptions as per business requirements.

●Upgraded EC2 instance type for appropriate configuration to optimize performance of the application from s3.small using credit points to save cost for the company and upgraded burst mode to c7a.large,c7a.xlarge wherever needed.

●Backup and restore of Aurora postgresql database and refreshing database at Dev QA and UAT for optimized testing with recent data changes.

●Enabling pg_stat_statements for tracking the queries performance to trace and optimize based on provided metrics.

●Performed AWS database encryption for more secured database environment for end-to-end encryption.

●Handled Xml data for SQL for update and rollback changes used by the tags and sensors for robotic needs.

●Handled robotic sensor data based on collecting vibration from NATS to Quasar databases using EC2 instance of postgresql and reading data from s3 bucket files.

●Involved in various version upgrades and data leak fixes for Quasar database servers and actively monitoring the linux database environment for loopback, heavy data load and connection limit fixes.

●Worked on Quasar DB versions migration from 3.12 to to 3.14 for required database servers.

●Adding and enabling roles needed for cloud watch for alerting mechanism to validate the threshold changes and escalate issues accordingly using AWS cloud watch services.

●Worked on User defined functions to fine-tune and vacuum databases along with analyzing stats for getting faster results used for robots and AI generated systems like ChatBot and data analytics for Neo4J connected systems.

●Handled AWS cloud and Quasar database versions inventories for across EAA database environments.

●Upgraded MYSQL 5.7 database server to MySQL 8.0 versions for support using AWS compatibility due to end of life and support extensions used by database servers.

●Fixed various issues for enabling parameters to enable and run extensions for AWS and mysql databases.

●Fixed triggers and stored procedures during migration process of database server and its versions on AWS cloud database environment.

●Handled storage issues and DB connection issues due to timeout of application to fine-tune required functions and usage of indexes wherever needed.

●Worked on administration of cloud database environment along with implementing Dynatrace and cloud watch alerting system.

●Handled AWS EC2 postgres linked servers for connecting to Quasar database using RestAPI connections so that all queries can be tracked and monitored with AI tools like AWS Glue and Generative AI and Machine Learning along with Lambda uses for ETL process in Alert Mechanism.

Tools Used: AWS Redshift Database,PostgreSQL.Neo4J GraphDB, QuasarDB AWS MySQL5 to 8.0, MS SQL Server 2016-2022, MS Visual Studio, Idera,CloudWatch, AWS RDS,AWS Aurora,AWS EC2,S3Bucket, BI SSIS, SQL DM, Solarwind, GIT CICD

State of Ohio - Ohio Department of Development July 2022 – June 2024

SQL DBA LEAD

●Database implementation migration from legacy version to latest SQL server version using Business Intelligence integration tools like SSIS, SSRS Visual studio for Report system migration upgrade and fixes for failures during deployment process.

●Data analysis, querying database, and data integration with SQL Server and TSQL. Build features containing measurement of trend, periodicity, Skewness, nonlinearity, and self-similarity.

●Create and validate database models. Develop a risk prediction model to make recommendations for reducing risk dealer scores.

●Develop Model layer: feature engineering, use of aggregated features grouped by factors and their combination. Build model output, summary statistics.

●Develop ETL stored procedures, SSIS mapping and merge processes along with code review for the team.

●Ensure all software products, applications and data meet the highest possible quality standards by following industry recognized agile methodologies using best practices.

●Perform extensive ETL data flow in Source, Staging, warehouse field using Microsoft SQL server BI tools.

●Experienced in utilizing SQL within Amazon Redshift for data analysis across diverse data environments including data warehouses, operational systems, and data lakes on AWS.

●Create and Maintain SQL databases in AWS SQL Server and Azure SQL Managed cloud environment as well as On Premises database SQL Servers 2014,2017,2017 2019 and 2022 versions.

●Azure SQL IAAS SQL Managed Instance Azure SQL including Amazon AWS AMI SQL Server 2014 and 2019 implementation process for upgrade and maintenance of Dev QA and Production database servers.

●Performed Amazon AWS SQL Server Database version upgrade from 2014 to 2019 to 2022 for database migration and archival process.

●S3 Bucket file management with Sync from SQL server to S3 location with retention of files based on policy. Installed and implemented SQL Server Using AMI for the migration process.

●Performed index maintenance and Archival task on GP databases including SSRS report server databases.

●Created PowerShell scripts for backup transfer to S3 bucket on AMAZON AWS cloud location with backup sync and profile management. Created archival process for SQL tables to reduce storage usage and save cost at Azure SQL Managed instance.

●Managed Microsoft SQL Azure (RTM) - 12.0.2000.8 with Index maintenance for performance tuning, Data archival for saving storage cost.

●Data modeling and designing of databases using Erwin tool for reverse and forward engineering’s Software implementation and upgrades along with monitoring tools upgrade based on version releases for patch and hotfixes required to be updated.

●Perform Database Security, Auditing of database users access based on required permission granted and integrity check.

●Used Idera SQL Diagnostic Manager and SolarWinds SQL Sentry to fine tune alerts based on baseline matrix’s and further improve performance on provided recommendation after analysis.

●Perform database backups Native and on azure blob storage and perform restore, recovery based on need by the business.

●Used SSDT, SSIS to do the Database table migration by creating required schema and mapping the table data types and database objects.

●Worked on SQL EOL to bring database servers up to current reliable version from downstream to upstream production database environment using SDLC cycle. Database scripts review and deployment across all database instances. Worked on Data Dog HQ for monitoring and implementing Database Infrastructure and APM for Performance check and alerting system using CloudWatch services in Amazon AWS environment.

Tools Used: MS SQL Server 2014-2022, MS Visual Studio, SSDT, Visio, Always on HA SQL Cluster, Idera, Business Intelligence SSIS, SQL DM, SQL Sentry, Spotlight, Idera, BI SSIS, Erwin, ADF,Amazon AWS EC2 Instance,S3 Bucket, AMI, Data Dog

Zelis Healthcare Sept 2020 – June 2022

Senior DBA LEAD Atlanta GA

●Create and Maintain SQL databases in Azure cloud environment as High Availability and On Premises database servers. Azure SQL IAAS PAAS SQL Managed Instance Azure SQL

●Perform Database Security, Auditing of database users access based on required permission granted and integrity check.

●Performance Tuning and monitoring with Idera SQL Diagnostic Manager and SolarWinds SQL Sentry to fine tune alerts

●Perform database backups Native and on azure blob storage and perform restore, recovery based on need by the business.

●Utilizing SQL within Amazon Redshift for data analysis across diverse data environments including data warehouses, operational systems, and data lakes on AWS.

●Troubleshooting Data issues during batch process runtime and fixing data migration from source to destination.

●Mapped Attributes and respective columns based on best practice to transform that Data from Source to Destination. Used SSDT, SSIS to do the Database table migration by creating required schema and map the table data types and database objects.

●Used BI tools which include SSIS SSRS SSAS as per data needs across the organization.

●Implemented SQL SERVER ALWAYS ON Payment, Prizem, Network solutions and compass application in OnPrem environment Azure SQL IAAS PAAS on cloud DB Managing database maintenance task for Up to 30 TB single database size includes Index maintenance table compression update stats and various disk and resources cost saving for the organization.

●Worked on Multidimensional Expressions (MDX) for analytical processing using SSAS on OLAP using SQL databases for OLAP databases processing cubes using facts and dimensions to measure calculations based on analytics needs and implemented SQL Server analysis server.

●Worked on SQL EOL to bring database servers up to current reliable version from downstream to upstream production database environment using SDLC cycle.

●Database scripts review and deployment across all database instances.

●Migrated Database from DB2, Oracle to SQL server system with Database architecture along with Data Model and Design in for DB server with workflow diagram using Erwin and Implemented the Database migration process from DB2, Oracle database to SQL server Database.

●Used Delphix for backup restore of VM clones and Databases used by SQL server.

Tools Used: MS SQL Server 2008-2019, MS Visual Studio, SSDT, Visio, Always on HA SQL Cluster, Idera, Business Intelligence SSIS, SQL DM, SQL Sentry, Spotlight, Idera, Business Intelligence SSIS, Erwin, ADF(Azure Data Factory), Delphix

Verizon Sourcing LLC Jan 2019 – Aug 2020

DBA & Database Migration Specialist Atlanta, GA

●Database migration for SQL server to PostgreSQL using Amazon AWS Aurora PostgreSQL with structure changes based on PostgreSQL Data Masking for the existing databases in lover environment like UAT, Development and Test environment for sensitive data and the databases with scrubbing the data for limited access to databases and important information restrictions.

●Performing exploratory data analysis, querying database, and data integration with SQL Server and Amazon Aurora PostgreSQL for Data Analysis and interpretation. Amazon Data Migration Service to perform extensive data flow in Source, Staging, tables, for application and reporting databases from SQL Server to Amazon Aurora PostgreSQL.

●Develop the migration analysis documents, migration strategy document, test case and test result document for end-to-end migration for the following activities of Deliverables for migration.

●Performing Assessment using Schema Conversion tool of Amazon to verify proper conversion and troubleshooting based on validation results.

●Migrate databases and database objects mentioned below from on premise SQL Server 2008R2 databases to PostgreSQL databases on AWS RDS or EC2 instances.

●Database Migration from SQL Server Database to Amazon Cloud Aurora PostgreSQL

●Cloud environment using MS SQL Azure management for database sizing high availability with zero downtime.

●Maintain current patches and release enhancements for DB server and assess impact on currently running applications.

●Ability to manage EDW and services related to data analytics such as ETL process.

●Used Azure data factory to integrate using ETL for data integration.

●Migrated SQL Server Database to the cloud to preserve ETL processes and reduce operational complexity using Azure Data Factory to rehost on premises SSIS packages with minimal effort on cloud using Azure SSIS Integration runtime.

●Transferred data using prebuilt connectors using Amazon S3 for data transformation.

Tools Used: MS SQL server 2014/2016/2017/2018/2019, SSMS, AMAZON Schema Conversion Tool (SCT), PgAdmin, DBeaver, Data Migration Service (DMS), EC2, RDS, SCT SSDT, Visual Studio .Net 2017/2018, VSTS, Database Project, Bac Pac & DACPacs, GitHub for integration, CICD, Azure SQL Cloud Environment, Jira, Business Intelligence SSIS, Erwin, MS SQL server 2019, MS Visual Studio.Net 2019, DB2, Oracle, SSDT, Visio, Always On HA SQL Cluster, MS SQL Server 2014-2022, MS Visual Studio, SSDT, Visio, Always On HA SQL Cluster, Idera, Business Intelligence SSIS, SQL DM, SQL Sentry, Spotlight, Idera, Business Intelligence SSIS, Erwin, ADF(Azure Data Factory),Amazon AWS EC2 Instance,S3 Bucket, AMI,Data Dog

Cox Automotive Aug 2018 – Dec 2018

Database Migration Specialist New York

●Gathering requirements and managing with rally for story points as scrum master for the code implementation and integration based on the customer requirements for Nissan and Honda.

●Integration with a banking app for the loaning form.

●Fixing data with data analysis, querying database, and data integration with SQL Data Analysis and interpretation.

●Evaluated different machine learning algorithms. Mapped DB2 Schemas to SQL server schemas and view assessment report to access database objects for conversion and estimate the conversion time.

●Loaded converted DB database objects to SQL server for synchronizing the database objects.

●Setting client side or server-side Data migration engine in project setting for SSMA using extension packages for DB2 to SQL server migration.

●Used DB2 Metadata explorer to migrate data for all schemas on SQL server instance making sure SQL server Agent service running while using server-side migration using server-side data migration engine in project setting of SSMA Successfully migrated from DB2 to SQL server with validation of reports including data transformation.

●SSDT tool for data integration projects related with database migration and including recursive changes.

●Ability to manage EDW and services related to data analytics such as the ETL process. Oracle to SQL and SQL to Oracle using linked servers.

Tools Used: Scrum Master Rally, Business Intelligence SSIS, Salesforce, MS SQL server 2012/2016, MS Visual Studio.Net 2017, DB2, Oracle, AWS S3, Data Integration, SSDT, PostgreSQL

Dubai Municipality Jun 2017 – May 2018

Senior DBA Manager Dubai

●Managing DB2 database for data transformation to SQL server using linked server using MS OLE DB provider for DB2

●Optimization of Database server with regular fine-tune and providing custom solution based on Client data requirement with Authorization approval using SSIS integration BI system.

●Worked on RBS for OneDrive and iOffice for SharePoint configuration with Drive encryption as per security requirement for file stream.

●Performance analysis and load management based on Always On technology of SQL server for balancing the load and having High Availability for all SharePoint Databases in synchronized mode for load balancing with read-only and read-write wherever needed.

●Managed Database growth for SharePoint databases and application databases.

●Database management for the production environment for BI Integration and migration projects Oracle to SQL and SQL to Oracle using linked servers.

Tools Used: Business Intelligence SSIS, MS SQL server 7.0/2000/2005/2008/2012/2014/2016, HA Always ON, MS Visual Studio.Net 2015, DB2, Oracle, SSDT, LANDesk, SolarWinds, PostgreSQL 8.5/9.0/9.1/10.0.

Deloitte Apr 2017 – May 2017

Senior DBA Manager Dubai,UAE

●Creating and Managing CIR-CRM opportunity data for global customer integration and implementation using SSIS Packages from Microsoft Dynamics 365 ERP & CRM.

●Managed Always On database for High availability and implementation of Automated agent jobs for health check of production database servers and automated alert integrations.

●Fixing databases with a proactive alert mechanism. Backup jobs management and integration management and fixing packages related to IT audit.

●Managed applications and databases as per IT Architecture and SDLC. Used T-SQL to compare different table data of source and destination to confirm the sync as per DATA WAREHOUSE needs.

●Used SQL to perform and check database health including tables locked by the user and checking active sessions.

Tools Used: Business Intelligence SSIS, MS SQL server 2014, HA Always ON, SSDT, MS Dynamic CRM

Emirates National Bank of Dubai Aug 2016 – Feb 2017

Senior Consultant- Tools and Automation - Database Migration Specialist Dubai,UAE

●Experience in migration of Fog Light versions including application and database upgrades from 5.6.10 to 5.7.1 to 5.7.5.5.

●Worked with all Unix and Linux flavors including AIX Solaris, SunOS to implement Fog Light for host monitoring in banking domain for 4000 + environment including database monitoring for Oracle Databases, SQL Databases, Sybase databases, jvm applications like WebLogic, WebSphere applications server monitoring at Fog Light enterprise level.

●Automation of alert mechanism to avoid manual health check using Fog Light application by Quest/Dell product Fog Light enterprise management solution.

●Deep analysis of fatal, critical alerts, Custom rules management including cartridge install and upgrades with debug skills for data configuration Groovy script modifications used by cartridges and alarms including hosts and database cartridges.

●Fog Light Transaction management FTR for URL monitoring, process monitoring by web pages. Currently MongoDB & Cassandra monitoring cartridge implementation for database cartridge new release updates under 5.7.5.35.

●Resolved several issues after the upgrades from 5.6.10 to 5.7.5.5 Resolving false alerts and custom management of inherited objects as per banking project requirements based on application and servers used.

Tools Used: SQL server 2012\2014, SSRS, Quest Fog Light, SolarWinds, Linux, Solaris, AIX, Oracle RAC DB

TMX Finance Family of Companies Mar 2012 – Aug 2016

Senior Production DB Engineer & DBA Alpharetta, GA

●Production SQL Server Database support for servers including replication/mirroring and clustering with all High Availability techniques related to database servers.

●Database manager to ensure all nightly tasks scheduled database related tasks run as expected per requirement of business.

●Ensuring SQL cluster and replications are working as per job requirements for production systems.

●Transferred effective knowledge to team individuals. Collaborated with stores and team on specification analysis and detailed design related to database architecture and product.

●Controlling Database changes using TFS build control to have recent changes performed in production from version to version with correct build releases for production.

●Implementing new database systems along with through analysis for the business requirement to have database jobs accomplished before time which helps in improving performance of production database servers along with application level used by reports generation.

●Worked with the Team to ensure that all outcomes matched the specifications given by the clients. Also dealing with SharePoint and project databases for resolving critical production issues.

Tools Used: BI SSIS, SSRS, SSAS, MS SQL server 2005/2008/2012/2014, HA SQL Cluster, Always ON, MS VS.Net, Idera SQLDM, DB2, Redgate, Sentry, Derdack, SCOM, SCSM, Oracle, MS Visio, JIRA

Yardi Software Inc. Nov 2000 – Feb 2012

Programmer Analyst/Implementation Specialist/Associate Tech Lead & DBA Pune&Silver Spring MD

●Software Implementation Specialist Visual Homes of Yardi Systems Inc. SB, USA. Highly experienced in installing IBM2 DB 2 database service and used DB2 connect for DBA and management.

●Managed DB2 Universal database along with DB2 connect for scripting and managing tables and data and integration with Sybase power builder application and Visual FoxPro.

●SQL server database development using Sybase Power Builder and Visual FoxPro for the customer and doing performance tuning for all that production databases for higher performance tuning for the business growth.

●DBA cum developer for databases in Oracle 8.0/8.1.5/8.1.7/9/10/11, MS SQL server 2000/2005/2008R2 Sybase SQL Anywhere 5.0 and VFP6.0/8.0/9.0.

●Procedural programming with Local variables handling using T-SQL. Used T-SQL to compare different table data of source and destination to confirm the sync as per DATA WAREHOUSE.

●Creating and maintaining installation, Index performance tuning, backup, restore, security and disaster recovery.

Tools Used: BI SSIS, SSRS, SSAS, MS SQL server 6.5/2000/2005/2008/2012, HA SQL Cluster, MS Visual Studio .Net, VFP, TFS, VSS, Oracle, IBM DB2, MS Visio, LiteSpeed, PowerBuilder, SQL Anywhere, Lotus Notes

Contact this candidate