Sql Server DBA

Muhammad Khan

********@*****.*** 678-***-****

Summary:

Over sixteen plus years of experience in Database Administration, Systems and Network Management. DBA skills include analysis of business requirements, migration, application testing, implementation and maintenance of databases using DB2, IIDR, MQ Series, SQL Server and PostgreSQL technologies on UNIX, LINUX, and Windows Platforms. Proficient in Installation, Configuration, Development, Administration, Maintenance, Performance Tuning, Security, high availability, disaster recovery, and troubleshooting. Expertise across Insurance, Banks, Automobile, Financial Institutions, ITAR, FDA and HIPPA regulated industries. Demonstrated experience managing large-scale systems for Fortune 500 organizations such as IBM, General Motors Corporation (GMC), AT&T, Delta, Kaiser Permanente, Blue Cross Blue Shield, and various state government accounts. Demonstrated adeptness to lead cross-functional teams in implementing and developing product playbooks. Strong client interfacing and project management skills. Exceptional written and verbal communication skills, demonstrated through effective collaboration with cross-functional teams, stakeholders, and clients at all organizational levels.

Technical Skills:

RDBMS: IBM DB2 LUW/Connect 10.x, 11.x, PostgreSQL 12.x, MySQL Ver. 8.x and MS SQL Server versions 2012/2014/2016/2019/2022

Tools: IIDR CDC Replication, MQ Series, DB2 HADR, Toad for DB2, SSMS, ITSM, PGAdmin, Microsoft Office skills (Excel, Powerpoint, Access, Teams),

Operating System: AIX, linux, and Windows

Hardware: Window Server, IBM’s P-Series System, zlinux

Cloud Technologies: Azure, Docker, Kubernetes (OpenShift), and Lens

Networking: TCP/IP, NIS, NFS, DNS, SAN, HACMP, TLS/SSL

Languages: HTML, PowerShell, T-SQL, Shell Scripting

Project Management: Microsoft Project, RFS, Lean, Agile Scrum methodologies. Customer Facing and Negotiating Skills, SLA (Service Level Agreement) Negotiation

Experience:

IBM (Truist Bank client) Atlanta, GA September 2024 – Present

DataBase Analyst

Designed and managed real-time data pipelines using IIDR to replicate data between DB2, SQL Server, PostgreSQL, and Snowflake, ensuring seamless integration for analytics and reporting.

Installed, customized, and administered database software releases for DB2 versions 10.5 and 11.x, SQL Server, Snowflake and Data Management Tools on Linux

Conducted comprehensive DB2 database maintenance tasks, including backups, restorations, performance monitoring and tuning, log management, issue identification and resolution, security enforcement, and disaster recovery planning.

Configured and maintained Apache Kafka clusters to handle high-throughput data ingestion and event-driven architecture.

Developed and automated Kafka Connect configurations to enable data flow between Kafka topics and downstream systems. Monitored and optimized Snowflake database queries and resources to reduce costs and improve performance.

Wrote CHCCLP scripts to configure and manage IIDR subscriptions, mappings, and replication monitoring.

Performed database performance tuning and optimization for DB2, SQL Server and PostgreSQL environments, including index tuning, query optimization, and partitioning.

Collaborated with cross-functional teams to gather requirements and implement data workflows tailored to business needs.

General Motors Corporation (GMC) Remote July 2017 – September 2024

SQL Server DBA, Technical Team Lead DB2, Postgres, and IIDR

Technical lead to support DB2 software solutions for large scale e-business projects, involving clients across North America, Europe, and Latin America.

Proficient at configuring, monitoring, and troubleshooting complex data replication processes using IBM InfoSphere Data Replication.

Manage and maintain the (IIDR environment, ensuring seamless data replication across multiple databases including SQL Server DB2, Oracle and Snowflake.

Conduct IIDR performance tuning and optimization for replication processes, reducing latency and improving throughput.

Install, configure, and upgrade Kafka brokers, ZooKeeper, and related components.

Manage and optimize Kafka topics, partitions, and replication factors.

Assist in detecting software, hardware, and Network connection problems and present the best possible solution to the customer.

Installed DB2 products, catalog nodes and DBs on CLI, and applied security patching and upgrades.

Implement instance DBM and DB configuration (cfg) and set up auto scripts through crontab, AutoSys.

Built of Data Partition Feature (DPF), containers, logical and physical storage, storage groups and manage authentication and grant privilege.

Performed DB2 database maintenance, backup, restore, performance monitoring and tuning, log maintenance, problem identification and resolution, security, and disaster recovery planning.

Examined Diagnostic log (db2diag.log), IBM Data Management Console (DMC), and db2top for DB and security consistency.

Involved in managing PostgreSQL databases, managing installation, including security access, upgrades, and production deployments.

Involved in working with opensource database including PostgreSQL to minimize footprint and reduce cost of the on-premises databases such as SQL Server.

Monitored database health and performance using tools like pgAdmin, Grafana, and custom monitoring scripts.

Implemented and maintained backup and recovery strategies, including point-in-time recovery (PITR) and automated backup scripts. Conducted database backup and recovery procedures using tools like pg_dump, pg_restore, and pgBackRest, ensuring data integrity and availability.

Created and managed Postgres database users, roles, and permissions to ensure data security.

Collaborated on numerous management initiatives, including Data Security, Database Backup and Restoration, Data Management & Data Retention & Resource Tracking, Change Control, Disaster Recovery Planning and High Availability.

Involved in administering several SQL Server databases for various on-prem and cloud technologies including Azure for MFG, GPSC and OnStar verticals.

Responsible for building new SQL Server 2022/ 2019/2016/2014 instances and upgrading from older versions to new SQL Server versions based for various databases to stay compliant.

Involved in migrating SQL Server databases to Azure SQL/ Managed Instances based on application requirements.

Installed and administered a four-node Active/Passive cluster on Microsoft Windows Server 2019 Enterprise Edition.

Configured Windows Failover Cluster, Set up the Always On Availability Group.

Performed SQL Server patching and database updates on over 2,000 servers using IBM BigFix.

Installed and configured SSIS and SSRS. Used multiple sources as linked server (ODBC & MS Access) to connect to the SQL Server Database.

Experienced in using DMVs, DBCC, performance tuning, mirroring, database snapshots, and tracking performance counters.

Implemented comprehensive backup plans and disaster recovery strategies, ensuring database recovery from backups in case of disasters.

Scheduled Full, Differential and Transactional Log Backups for users and system databases in the production environment. Implemented Point-In-Time Recovery solutions.

Monitored use of disk space usage, memory, and CPU Usage.

Managed SQL logins, roles, and authentication modes as part of security policies for various user categories.

Responded to SQL Server alerts for disk space alerts, Job failures and other performance related issues.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Deployed new code base release to UAT and Production Environments.

Installed and customized MS SQL Server backup technologies utilizing DDBoost/NMM.

Created and implemented MS SQL Server database security best practices.

Coordinate internal audits to ensure that all process documentation is current and continually updated and maintain testing plans for all identified business and IT key controls.

Assisted the Project Manager with project plans involving DB2 tasks and created playbook for Help Desk, LAN Administrations.

Participated in 24x7 support for production systems through an on-call rotation.

Evaluated and analyzed customer requests, made recommendations, and created project plans. Collaborated with Project Managers and Application Developers to accomplish DB2 and MS SQL Server tasks.

Artech Information Systems (IBM Client) Columbia, MO October 2015 – May 2017

DB2 Administrator

Installed, customized, and administered database software releases for DB2 versions 9.x and 10.5, including DB2 ESE, DB2 Connect ESE, DB2 Workgroup Server Edition, DB2 Developers Universal Edition, DB2 Warehouse Manager, DB2 Data Management Tools, and DB2 Content Manager on AIX, Windows, and zLinux platforms.

Created and managed databases, tablespaces, and indexes, and performed data import and export operations.

Conducted performance tuning for both databases and applications.

Performed DB2 database maintenance, including backup, restore, performance monitoring, tuning, log maintenance, problem identification and resolution, security, and disaster recovery planning.

Provided recommendations and designed solutions for backup and recovery techniques, including High Availability Disaster Recovery (HADR) and HACMP strategy configurations.

Managed and administered IBM MQ environments across multiple platforms, ensuring high availability and reliability of messaging services.

Configured and maintained MQ objects such as queues, channels, listeners, and queue managers to support business applications.

Defined and configured TCP/IP router mapping from DB2 servers to clients.

Created and updated DB2 instances, cataloged databases, executed load, delete, backup, and restore operations, and handled database and instance migrations to newer DB2 versions.

Created and presented architectural solutions for data flow from mainframe to DB2 client servers using DB2 Connect, providing details of the end-to-end process.

INTERNATIONAL BUSINESS MACHINES (IBM) Southbury, CT January 2008 – August 2015

DB2 and LDAP Technical Project Lead

Served as the technical lead in architecting and implementing DB2 and LDAP software solutions for large-scale e-business projects involving clients across North America, Europe, Latin America, and Asia Pacific.

Created and maintained scripts for data loading, extraction, and transformation.

Assisted the Project Manager with project plans involving DB2 tasks, and wrote documentation for Help Desk, LAN Administration, and DB2 installation.

Coordinated internal audits to ensure that documentation of all processes is current, continually updated, and maintains testing plans for all identified business and IT key controls.

Assisted in detecting software, hardware, and network connection problems, and presented the best possible solutions to customers.

Installed and configured WebSphere to maintain LDAP with a DB2 backend.

Evaluated and analyzed customer requests, made recommendations, and created project plans while working with Project Managers, IT Architects, and Application Developers to accomplish DB2 tasks.

Led commercial and internal projects, providing the best possible technical solutions to customers for various IBM products, including DB2, LDAP, Notes, AIX, and Linux on Intel.

Education & Training:

MS - Computer Science, Hampton University, VA.

BS - Accounting, Christopher Newport University, Newport News, VA.

FDA Certification.

HIPPA Certification.

IBM - Certified Administrator - Lotus Notes (Domino).

IBM - Certified Administrator – DB2 UDB DBA V9.

Awards/Recognitions:

The Best IBM Bravo! Award.

The IBM Recognition Award.

Received multiple General Motors awards for outstanding contributions and teamwork.

Work Authorization:

US Citizen.

References:

References available upon request.

Contact this candidate