Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Sr Database Consultant
IBMSr Database Consultant
Jan. 2021 - Jul. 2024Greenville, South Carolina, United StatesOversee database installations, configurations, and maintenance to ensure optimal performance across various platforms including SQL Server, Oracle, MySQL, MongoDB, and PostgreSQL. Design and implement robust backup strategies for diverse database environments. Conduct comprehensive capacity planning for database resources and align with business unit requirements for CPU, RAM, and Disk Management. Execute complex cloud migrations, while transitioning on-premise databases to AWS and Azure PaaS offerings with a focus on EC2, RDS, and managed instances. Streamline database operations by developing and maintaining detailed documentation and standards. Notable Contributions/Accomplishments: • Migrated critical databases to AWS and Azure cloud platforms (Aurora,Dynamo) to enhance scalability and reduce infrastructure costs. • Optimized SQL Server performance by resolving query inefficiencies, deadlocks, and locking issues, leveraging advanced SQL tools. • Implemented Liquibase to manage database schema changes and improve deployment efficiency for application and database updates. • Built and configured AWS VPC’s,Subnets and Security Groups needed for data connectivity. • Facilitated seamless database restorations from AWS S3 buckets and ensured business continuity and data availability. • Played a pivotal role in Oracle to PostgreSQL database migrations, utilizing AWS Schema Conversion, DMS, and ora2pg tools. • Designed and implemented CI/CD pipelines using Azure DevOps, enabling automated builds, tests, and deployments. • Instrumental in deploying containerization (Docker and Kubernetes) to SQL Server. • Built and configured Mysql innodb cluster with multiple nodes primary and multiple nodes replica sets.
Sr Database Consultant
HMSSr Database Consultant
Jun. 2020 - Dec. 2020Irving, Texas, United States➢ Responsible for performance, security, and integrity of the database as well as planning, architecting, developing, and managing databases and procedures to support the Accent enterprise applications and business functions. ➢ Develops database architecture and standards. ➢ Configured and maintain High Availability methods on multiple database platforms such as: Always On(SQL Server), DataGuard, SharePlex, GoldenGate(Oracle) ➢ Configured and upgraded database software for SQL Server, Oracle and other database platforms. ➢ Evaluate database features and related products. ➢ Performs database application tuning and performance monitoring. ➢ Provided consultation and troubleshooting for the development team. ➢ Mentorship and knowledge transfer to junior level dba team members. ➢ Established and maintained sound backup and recovery policies and procedures. ➢ Setup and maintain database documentation and standards. ➢ Interface with database vendors for technical support. ➢ Provides 24X7 database support for production databases for Oracle, SQL Server, AWS and other database platforms. ➢ Deployed changes into production for the development teams for Oracle and SQL Server platforms ➢ Apply SQL server hotfix patches and updates to database environments. ➢ Apply Oracle SPU and OVJM patches to database environments.
Sr Database Consultant
SMEDemand ConsultingSr Database Consultant
Oct. 2014 - Mar. 2021Dallas/Fort Worth AreaMonitored SQL Server databases for multiple clients, ensuring optimal performance and health from database, web, and application perspectives. Managed migrations of SQL Server databases to AWS and Azure cloud platforms using various methods. Served as the first point of contact for technical escalation issues. Conducted troubleshooting for database performance, including query optimization, user access issues, and capacity planning. Led the installation, configuration, and maintenance of Mongo, PostgreSQL, and Oracle database systems on various operating systems. Oversaw security and configuration standards for user accounts and databases across production and non-production environments. Conducted regular refreshes of development and test instances with production data using DELPHIX. Created and managed virtual databases and servers in Microsoft Azure for streamlined management and publishing of on-premise databases to the cloud. Notable Contributions/Accomplishments: • Managed a diverse database environment with sizes ranging from 50GB to 4TB, ensuring data integrity and accessibility. • Implemented a three-node Mongo database replica set with a two-node failover for robust disaster recovery. • Conducted performance tuning and capacity planning for production SQL environments, leading to enhanced system efficiency. • Deployed SQL scripts across development, quality assurance, and production environments, ensuring error-free releases. • Generated insightful reports using SQL Server Reporting Services (SSRS) to aid in data-driven decision-making processes.
Sr DBA
MedAssetsSr DBA
Apr. 2014 - Aug. 2014Plano, Texas, United States➢ Migrate of over 500 SQL server databases. ➢ Troubleshoot and modified SQL server replication, log shipping and mirroring. ➢ Tasked with stabilizing the backup strategies for sql environments using Litespeed software. ➢ Worked with monitoring group to baseline the alerts that need to be captured to effectively monitor the databases using Spotlight. ➢ Modifying the performance analysis tool from Quest software toolset. ➢ Performance tuning the production SQL environments and capacity planning. ➢ Upgrading SQL 2005 to SQL 2008 on over 15-20 instances. ➢ Managed SQL server clustering in DR and also a steady state environment using double take replication. ➢ Installed and configured Oracle 12c, setup monitoring and daily backups with archiving. ➢ Created new Oracle custom databases for the Capacity Manager Application on red hat linux environment. ➢ Deploying SQL scripts in Dev, QA, Prod environments using SQL Compare and SSMS. ➢ Review production deployment scripts that are thoroughly tested in staging environment with no errors and successful completion.
Senior Database Engineer(Contract)
McAfeeSenior Database Engineer(Contract)
Sep. 2013 - Jun. 2014Plano,Texas• Managed the complete support of multiple SQL and Oracle environments. • Troubleshoot and modified SQL server replication and log shipping. • Tasked with stabilizing the backup strategies for sql and oracle environments. • Worked with monitoring group to baseline the alerts that need to be captured to effectively monitor the databases. • Worked with SQL clustering on a 4 node cluster, installing and troubleshooting cluster issues • Wrote precise documentation for procedures for specific database task. • Conducted performance tuning the production SQL environments and capacity planning. • Supported Oracle Dataguard and RAC environments versions 10G and 11G. • Gathered, analyzed, and normalized key information related to and from the business process, functions, and operations to evaluate data and make productive decisions based on relevance and revenue for the company.
Sr Database Consultant (Contract)
AtosSr Database Consultant (Contract)
May. 2012 - Mar. 2013Arlington, Texas• Responsible for sql server 2008 R2 installations for 20-30 servers. • Creation of multiple databases for different platforms SQL\ORACLE. • Responsible for Oracle 10g installation for Unix and windows platforms for 10 servers. • Implemented and modified DTS packages (current and previous versions). • Installed and configure oracle grid control for database environment. • Setup replication and mirroring for sql server environments. • Handled 5 client transitions for ATOS Origin for physical and logical support (knowledge transfer from client in regards to the current state of the environment, hardware and software, information gathering, critical best practices, exceptions logging, monitoring setup, updates to the environment and steady state support). • Maintenance of the environments including upgrading different versions, performance tuning and proactively checking data availability, and ensuring data standards such as: storage, archiving, backup and recovery procedures are functioning correctly. • Worked with SAN technology for disk and LUN management for data and backup disk drives. • Wrote database documentation, including data standards, and procedures. • Practicing ITIL methods for incident, request, problem and change management. • Managed and upgraded the DTS packages into SSIS from SQL 2000 and 2005 to 2008 R2
SR ORACLE Database Consultant (Contract)
Frontier CommunicationsSR ORACLE Database Consultant (Contract)
Sep. 2011 - Mar. 2012Allen,Texas• Involved in large migration of 250 Oracle databases 9i,10g, and 11g • Involved with project planning for specific tasks for completion • Installation of Oracle software platforms including Oracle database 11g • Installed and configure oracle grid control for database environment • Creation of multiple databases for different applications • Managed and supported Oracle Dataguard environment that housed the grid database for online database management • Configure backups for databases with RMAN, export, and also EMC Networker • Setup Patrol monitoring for database environments • Steady state support for databases and applications • Documenting steps and procedures for database tasks • Following ITIL’s best practices for incident, request, problem and change management
Sr Database Administrator
DellSr Database Administrator
May. 2009 - Aug. 2011Plano,Texas• Handled numerous clients transitioning into the Dell model for physical and logical support (knowledge transfer from client in regards to the current state of the environment, hardware and software, information gathering, critical best practices, exceptions logging, monitoring setup, updates to the environment and steady state support). • Managed over 400 SQL Server (2000, 2005, 2008,2012) and 50 Oracle environments. • Installed SQL Server Versions and Oracle 10g for new environments on Windows Server 2003 and AIX 5.0, HPUX 11, Red Hat Enterprise Linux 5. • Experienced with configuring RMAN backup\recovery and executing Data Pump export and import methods. • Configured Oracle Enterprise Manager and Grid Control for online database administration (user security privileges, table spaces, objects, etc.). • Supported High Availability Methods Oracle Clusterware and RAC 10g,11g on multiple nodes including dataguard and managing ASM instances as well. • Created and tested backup plans for all databases SQL Server (Database maintenance plans) & Oracle (RMAN 9i, 10g and OEM). • Installation and configuration for monitoring for the SQL Server (NetIQ) which included adding alerts for baselines, setting thresholds and schedules and actively monitoring activity for NetIQ, responsible for troubleshooting and restoring incidents reported through NetIQ. • Maintained environments including upgrading different versions, performance tuning and proactively checking data availability, and ensuring data standards such as: storage, archiving, backup and recovery procedures are functioning correctly. • Wrote database documentation, including data standards, and procedures. • Worked closely with IT project managers, database programmers and application developers to effectively maintain the environments. Assisting with developing and supporting the applications and providing daily 24x7 on-call support for environments.
Sr Database Administrator
AtriumSr Database Administrator
Oct. 2008 - May. 2009Dallas/Fort Worth Area• Managed over 150 SQL Server (2000 and 2005) and 6 oracle database environments and 1 oracle apps environment. • Managed cloning and patching (prod, test, dev. for oracle 10g and prod, test, dev. for data warehouse). • Implemented log shipping for Get Paid application. • Installed SQL Server Versions & Oracle 10g for new environments on Windows Server 2003 and Red Hat Enterprise Linux 5. • Involved in migrating Oracle environment from Oracle On Demand to In-house support. • Consolidated SQL Server environments from old hardware to new hardware by moving databases from server to server. • Developed stored procedures for Buy Design online window ordering system using triggers (insert, update, delete) Cursors, etc. • Worked closely with Buy Design vendor for implementation of application and software creating linked servers with OLEDB for prod, test, and dev. • Created and tested backup plans for all databases SQL Server (Database maintenance plans) and Oracle (RMAN 10g). • Maintained environments including upgrading different versions, performance tuning and proactively checking data availability, and ensuring data standards such as: storage, archiving, backup and recovery procedures are functioning correctly.
Database Administrator
Perot Systems Government ServicesDatabase Administrator
Mar. 2007 - Oct. 2008Plano, Texas• Managed over 400 SQL Server (2000 and 2005) and 50 Oracle environments. • Installed SQL Server Versions and Oracle 10g for new environments on Windows Server 2003 and AIX 5.0, HPUX 11. • Experienced with configuring RMAN backup\recovery and executing Data Pump export and import methods. • Configured Oracle Enterprise Manager and Grid Control for online database administration (user security privileges, table spaces, objects, etc.). • Created and tested backup plans for all databases SQL Server (Database maintenance plans) and Oracle (RMAN 9i and 10g). • Setup monitoring for the SQL Server (NetIQ) and Oracle environments (BMC Patrol). • Maintenance of the environments including upgrading different versions, performance tuning and proactively checking data availability, and ensuring data standards such as: storage, archiving, backup and recovery procedures are functioning correctly. • Writing database documentation, including data standards, and procedures. • Worked closely with IT project managers, database programmers & application developers to effectively maintain environments.
System Administrator
Bank of AmericaSystem Administrator
Aug. 2006 - Apr. 2007Dallas/Fort Worth Area• Traveled to Newark, DE for extensive training to learn Legacy MBNA procedures for system administrators. • Monitored all of Bank of America online applications and servers via PATROL. • Recognized critical issues, resolved critical issues and escalated non-resolved issues to the correct support groups. • Installed and configured UNIX OS such as RedHat and Oracle Enterprise Server. • Responsible for security and filesystem management within the OS (AIX,Solaris) using SAM-system administrator manager. • Responsible for weekly maintenance on production/development servers including backups and rebooting. • Also monitored Bank of America production and development servers via Tivoli Business System Management, Formula and Tivoli Enterprise Portal. • Responsible for daily reporting for shift turnover and quarterly releases using Crystal Reports version 10.
Intch is a Professional Networking App for the Future of Work
300k+ people
130+ countries
AI matching
See more people like Paul on Intch
IT
453430 people
18
Technologist, Project/Program Manager
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
ITDatabase Developer
47999 people
19
Manager @ Epic Force
15
Founder & CEO @ Cultivating Digital Inc
15
Data Analyst