SUMMARY

• A highly accomplished Database Technology Professional wif over 20 years industry experience leveraging Database technologies and cloud platforms in the design, development and implementation of large scale technology solutions.

TECHNICAL SKILLS

• Database Design, Data Maintenance, Database Security, Database Management
• On - Line Transaction Processing (Mission critical applications - Transactions); OLTP; Database Management System;
• MS Cluster Services; SQL Profiler; SQL Server Reporting Services; SQL Server Replication; Adhoc Reporting Services;
• Always-On Failover Cluster; Always-On Availability Groups;
• Database Design and Administration;
• Oracle v9i, v10g, v11g, v12c, v18c; SQL Server v6, v7, v2000v - v2017;
• MySQL v4, v5, v6, v7; Postgres v7, v8, v9, v10, v11; MongoDB v2.6, 3.2
• Implementations and performance tuning, clustering, replication and data migration
• VMWare, Hyper-V and AWS cloud, Azure Cloud, ADMS (Azure Data Migration Service); Azure SQL DW
• Microsoft SQL Server Migration Assistant ( SSMA ); Microsoft Power BI
• SQL Server SSRS, SSAS & SSIS, Database Clustering (Log Shipping, Data Mirroring, Replication);

PROFESSIONAL EXPERIENCE

Confidential, Wayne PA

DBA Lead / MS SQL Server Database Administrator

Responsibilities:

• Administration for very large and complex databases in SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Implemented Always-On Availability Groups (AAG) and HA/DR Troubleshooting
• Implementation of SQL Server High Availability and Disaster Recovery strategies.
• Implemented data transformation services for Bulk Loads wif SSIS and BULK INSERT
• Implemented SQL Server 2017 data compression, online indexing, Contained Databases, security TEMPprincipals and AAG.
• Performance tuning using DMV and dynamic management functions for finding out long running queries.
• SQL Server 2014 and 2016 migration from SQL Server 2008 / 2005.
• Support for Very Large databases (VLDB) and troubleshooting the problems.
• Meta Data Management, Log Management, IN-Memory Optimization, Database Cluster Tuning
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Creation of power shell scripts to support automation and simplification of administrative task
• Maintained cloud systems support and architecture documentation
• Developed strategy and implementation plan for transitioning MS SQL Server on premise to Azure cloud
• Implement user access and security procedures in accordance wif SOX requirements
• Created monitoring solution for production databases wif PowerShell, Solar Winds & SQL Server Mgmt Studio
• Created & Documented high-level SQL Server consolidation plan to upgrade older SQL Servers onto newer platforms
• Developed support plan for MS SQL Server databases including performance tuning & high availability requirements
• Documented plan to migrate SQL Server 2000 database into SQL Server 2012 instances wif very little complication
• Team designed and trained to follow Kanban or Scrum based on project or user story.
• Database Consolidation from MySQL & SQL Server into PostgreSQL Database (Data Warehouse Reporting)
• Administration of PostgreSQL multi node clustered and replicated environments.
• Monitoring of system performance utilizing PgAdmin, Debeaver and command line tools
• Maintained custom vacuum strategies at table and db level for performance.
• Configured log analyzation using pgbadger.
• Establish and document the PostgreSQL technology stack including standard operating procedures including startup/shutdown, backup/recovery, disaster recovery and fail over.
• Implement automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production and non-production environments
• Manage backup and recovery functions for a PostgreSQL reporting data warehouse environment
• Design initial data model & database design for NoSQL database solutions.
• Loaded multiple NOSQL databases including MongoDB, Couchbase, HBase and Cassandra.
• Setup alerting mechanism for both PostgreSQL database and supporting environment to ensure system health and maximum availability.
• Monitoring the bloat repot on all table and performing maintenance wif minimal downtime.
• Install and configuring Nagios check postgresql.pl plugins for Monitoring PostgreSQL instances.
• Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community.

Confidential, West Long Branch NJ

Technical Team Lead / MS SQL Server/MySQL DBA/JD Edwards Database Administrator

Responsibilities:

• Performance tuning exercises wifin MS SQL Server 2012/2014 database and application parameters
• MS SQL Server Performance tuning exercises wifin MS SQL Server 2014 database and application parameters
• MS SQL Server Always Encrypted utilization; Dynamic Data Masking utilization; JSON Support;
• MS SQL Server Multiple TempDB Database Files; PolyBase; Query Store; Row Level Security;
• Backups, Performance Tuning, Parameter/Configuration Optimization, Partitioning, Query Optimization,
• High Availability (RAC, Always On, Data Guard, HADR) Replication (Golden Gate, Native Replication)
• Log Shipping, Database Restore, Database Refreshes, Monitoring
• Meta Data Management, Log Management, IN-Memory Optimization, Database Cluster Tuning
• SQL Profiler, Indexing Optimization, Parallel Query Optimization, Storage Optimization (Data Files, Logs)
• 150+ MS SQL Server Database (Servers) housing over 900 SQL Server Databases - Consolidation/Data Migration
• Lead technical team on performing Oracle JD Edwards Enterprise One, Financials and Supply Chain Management.
• Performance tuning exercises wifin SQL Server 2012 parameters
• Performance tuning exercises utilizing SQL Server Indexing strategies (Utilizing SQL Profiler primarily)
• Performance Tune JD Edwards environments
• Replication of Data from JDE database into MS SQL and MySQL databases Platforms for reporting.
• Migration of JD Edwards production database to AWS EC2 instance
• Maintained AWS Security Group Access & Modifications
• Developed production HA/DR strategy using database mirroring and backup to S3
• MySQL Database administration and support and performance tuning on MySQL v5.6, v5.7.
• Provision MySQL instances, both in clustered and non-clustered configurations
• Production support for MySQL in both Windows and Linux environments.
• Backup and Recovery setup via scripts and 3rd party tools for the MySQL, Oracle and SQL Server Databases.
• Oracle12C Enterprise Metadata Management installation and deployment
• Autoconfig troubleshooting and Cluster maintenance. Database Cloning using new node method and backup and restore method.
• Oracle Enterprise Metadata Management - Impact Analysis, Annotation and Tagging functions, Reporting Source Lineage
• Utilize Oracle Golden Gate and Golden Gate Veridata for both one directional and bi directional data replication
• Architect & Administrator Hadoop, MongoDB, MySQL,Hadoop Cluster
• Architect & Administrator Hadoop Cluster; Hadoop HDFS; Hadoop Hive; Hadoop Map Reduce
• GG replication for changes from Oracle, SQL Server to PostgreSQL
• 300+ Oracle Servers housing over 2200 oracle databases - Consolidation/Data Migration
• 100+ MySQL Database - Consolidation/Data Migration
• Administration of 9.5/9.6 (20+ PRD DB’s. Data Ingestion, Data Model optimization, Table/Index Optimization
• Backup/Recovery, Performance Tuning, Data loads, Connectors to other environments, SQL Tuning
• Replication and Replica Management; Sync Management and Optimization;
• Optimization management of Query, Storage, Index, - Data Analytics Optimization.

Confidential, Mount Laurel NJ

Lead Database Administrator / MS SQL Server DBA

Responsibilities:

• Creating databases, managing transaction logs, sizing database and managing disk space usage and compacting database.
• Query tuning, table resizing, data file group reorganizations
• Managing database security (logins, roles, permissions)
• Manipulating database objects (tables, indexes, table data, creating table triggers, stored procedures)
• Data Transformation Services (Create packages, replication, transformations)
• Responsible for configuration and tuning of all SQL Server databases.
• Responsible for database file systems, device lay out and backup/recovery procedures of SQL databases.
• Responsible for database sizing requirements.
• Responsible for data model and data dictionary maintenance of database.
• Responsible for setting up user security access to SQL Server
• Troubleshooting of application issues, DB Performance issues and long running queries.
• Installation of SQL Server 2008 and its configuration and DB migration from SQL 2005 to SQL server 2012.
• Configuring, Monitoring and Troubleshooting DB Replication, Log shipping. database, excluding application-level access security which is administered by the user.
• Interfaces wif Microsoft to resolve Microsoft SQL Server issues or problems.
• Tuning and performance of SQL Server Database. This includes the development and implementation of automated alerts.
• Develop/Document SQL Server Standards and Procedures.
• Distributed Transaction Coordinator Service (linked servers, remote servers, remote stored procedures)
• Replication (Snapshot, Merge, Distributor Administration, Managing Publications, Subscriptions)
• Database backup and recovery
• Database query tuning, index tuning, application logs management, performance monitor Utilizing SQL Profiler primarily
• Large data loads and updates (refresh’s) from production into development environment

Confidential, Philadelphia PA

Technical Team Lead / MS SQL Server Database Administrator

Responsibilities:

• Lead technical team responsible for performing the performance tuning of the ERRECA Clinical Application and the databases associated wif the applications for which the databases were essential for.
• Performed ERRECA Clinical Application performance tuning (Query tuning, table resizing, data file group reorganizations)
• Production Support / Test Support / QA Support / Development Support
• Performance tuning exercises utilizing SQL Server Indexing strategies (Utilizing SQL Profiler primarily)
• Performance tuning on queries dat were poorly performing to identify ways to improve response time and through put (Utilizing SQL Profiler primarily)
• Reviewed Windows 2008, VMware and EMC SAN for areas of improvements. Made recommendations in these areas dat would benefit the over system performance.
• Review of the database architecture as a whole to determine areas of improvement when it came to performance tuning efforts
• Design SSAS cubes for data loads from flat file data sources (SQL 2012 SSAS)
• Management of Database Basics (Creating databases, managing transaction logs, sizing database and managing disk space usage and compacting database.
• Query tuning, table resizing, data file group reorganizations
• Managing database security (logins, roles, permissions)
• Manipulating database objects (tables, indexes, table data, creating table triggers, stored procedures)
• Data Transformation Services (Create packages, replication, transformations)
• Distributed Transaction Coordinator Service (linked servers, remote servers, remote stored procedures)
• Replication (Snapshot, Merge, Distributor Administration, Managing Publications, Subscriptions)
• Database backup and recovery
• Creating and managing SQL Server Agents (Alerts, Operators, job schedules, notification)
• Database maintenance
• Review ERRECA SQL Server 2008R2 database, file system layout and patch level to determine areas of performance improvement
• Performance tuning exercises wifin SQL Server 2005/2008R2/2012 parameters
• Database Performance Tuning (query tuning, index tuning, application logs management, performance monitor Utilizing SQL Profiler primarily)
• Large data loads and updates (refresh’s) from production into development environment
• Setting up SQL Server Replication to relocate existing database reports onto a separate database to relieve some database performance for the Online Users.

Confidential, Philadelphia, PA.

Technical Team Lead / MS SQL Server Database Administrator

Responsibilities:

• Lead technical team responsible for performing the Peoplesoft Financials, HRMS and Global HRMS environment.
• Production Support / Test Support / QA Support / Development Support
• Performance tuning exercises wifin SQL Server 2000/2005/2008 (R1/R2) parameters
• Performance tuning exercises wifin Oracle 11gR2 parameters
• Performance tuning exercises utilizing SQL Server Indexing strategies (Utilizing SQL Profiler primarily)
• Performance tuning exercises utilizing Oracle 11gR2 Indexing strategies (Automatic Database Diagnostic Monitor)
• Performance tuning on queries dat were poorly performing to identify ways to improve response time and through put (Utilizing SQL Profiler - MS SQL Server & Automatic Workload Repository - Oracle DB)
• Database Performance Tuning (MS SQL Server & Oracle)
• Performed typical database and server maintenance and backup procedures
• Database Backup and Recovery and Disaster Recovery Design and Implementation
• Large data loads and updates from production into development environment