Highly skilled and experienced senior Database Architect/Database Administrator with demonstrated success in information technology, database administration, and data warehousing. Proven expertise and strong ability to increase system reliability, ensure recoverability, and improve system performance. Proficient communicator effective at managing relationships between end users, strategic and senior leadership, and third-party vendors. Highly qualified with exceptional verbal/written communication skills to effectively resolve problems in a deadline-driven environment. Consistently promoted into various positions of increased responsibility. Areas of expertise include:
Enterprise Architecture Database Design and Administration Data Warehousing
Security Administration Diagnosis and Troubleshooting Systems Integration
RAC Technology Program and Project Management Problem Resolution
Platforms: Red Hat Advanced & Oracle Enterprise Linux 4.0/5.0/6.0, Sun Solaris 2.x, HP UX 11.X on HP Superdome, Windows 2003/2008 Server
Languages: PL/SQL, Java , Korn and Born Shell Script
Lead Oracle DBA01/2004 to CurrentMagellan Health ServicesMD
Serve as Project Lead for Oracle 10g/11g/12C RAC implementation projects; manage business critical production databases including installation, configuration, patching, upgrade, and automation.
Improve efficiency via capacity planning, space management, problem resolution, database monitoring, and performance tuning of production databases on a daily basis using Quest and Oracle tools.
Design, implement, and participate in the disaster recovery process and database backups.
Administer user security on the database level by implementation roles, profiles, and auditing to adhere to the Sarbanes-Oxley (SOX) and HIPAA requirements.
Develop proactive scripts to monitor threshold for tablespaces in various production databases and alert or page as necessary.
Provide 24/7 support of 10g/11g/12C databases as part of on-call operations team.
Train and mentor junior DBAs on Oracle RAC database and Clusterware administration.
Managed several 11 plus Terabytes warehouse databases in production, test and stress environments.
Designed and setup several 11gR2, 10gR2, 12c R1 RAC clusters (CRS, ASM, ASM LIB) ranging from 2 to 6 nodes on Oracle Enterprise Linux 4/5/6 in production and development environments.
Upgraded Oracle 11gR2 Clusterware environments to 12C1 Grid Infrastructure with 11gR2 database.
Database upgrade to 12C testing is in process.
Upgraded Oracle 10gR2 Clusterware environments to 11gR2 Grid Infrastructure with 10gR2 database.
Upgraded Oracle databases on 10gR2 to 11gR2, this involved upgrading several Tera bytes databases Upgraded Operating system on Linux 4 to Linux5 using RAC Add/Remove node procedure.
Saved $100,000 in monitoring software by designing a custom repeat paging mechanism using Grid Control 10g which has been upgraded to Grid 11g to use out of the box repeat paging.
BILAL MAHMUD Page 2 of 3 As a member of the Infrastructure Management and Automation team, responsible for managing Business critical Production Databases associated with installation, configuration, patching, upgrade, and automation.
Lead on Oracle Proof of Concept for in house setup, configuration and testing of EXADATA x2-2 Perform various infrastructure tasks on RAC servers which included changing subnet in OCR, moving Private Interconnect to isolated switches with Jumbo Frames and reconfiguring it to use bonding.
Developed and implemented disaster recovery plans/procedures and successfully recovered the Oracle 10g/11g RAC cluster due to corruption of ASM header and OCR files.
Setup and administer Grid Control 11g and 12C.
This included monitoring databases, logs for all resources and creating rules for notifications.
Migrated data from a four-terabyte 10.1.0.5 Warehouse Non-RAC database on HP-UX to RAC database on Linux using Data Pump technology.
Dramatically increased reliability and improved customer satisfaction through proactive database monitoring using customized PL/SQL scripts for tablespaces suspension and OEM monitoring Configure RAC services using Load Balancing techniques and work with users to connect applications using JDBC connections.
Tune Application queries to perform better in a data warehouse environment.
This involved using explain plain, tracing sessions, creating and refreshing Materialized views/Snapshots on regular basis Perform database tuning which included resizing SGA components, increasing size of undo segments, relocating data files, changing size and location of redo log Used 10g/11g RMAN to backup databases in archive log mode.
Utilize RMAN features such as compression.
Used NetBackup to backup databases to Tape from disk and directly to Tape.
Restore databases using RMAN point in time recovery techniques, restore/rename databases using RMAN Duplicate technique Setup and configured Oracle DBFW 12.1 to capture auditing for various databases in a centralized repository, additionally configured the Firewall in monitoring mode to capture the database traffic.
Manage/Maintain DWFW for alerts, configuration changes and issues.
Responsible for automating cloning and refreshing development, test databases with production data.
Consulted with application programmers and managers of other organizations to plan and schedule Oracle patches and upgrades.
Install, test, and deploy the RDBMS software with minimal interruption to services Resolve various ORA-600 and ORA-745 errors by finding solutions and work around with Oracle support.
Configured Oracle Physical Standby for several POC projects and RMAN backup testing.
Worked in VMware setup to test various Oracle upgrades.
Additional tasks performed creation of schema objects (tables, partitioning, views, indexes, packages, triggers, etc.), Code walk through and enhancement with the developers.
Installed, configured and monitor Oracle Database and Firewall 18.104.22.168 to centrally collect audit logs from several Oracle and SQL Server databases.
Setup and worked with Hadoop (Cloudera) on Oracle Virtual Box for the proof of concept Limited knowledge and experience with Oracle MySQL.
Oracle DBA/Software Engineer05/1999 to 12/2003Verizon CommunicationsSilver Spring, MD
E-Business Developed SQL Loader scripts for 20 batch jobs to quickly load 22 million rows of data into tables from various data files and sources daily to refresh wireless customers for enrollment process.
Maintained six oracle environments and provided monthly database maintenance support on ONE-BILL application.
Installed and configured Oracle 22.214.171.124.0 to migrate ONE-BILL database; converted schema, views, packages, stored procedures, and triggers BILAL MAHMUD Page 3 of 3 Designed and developed Web based ONE-BILL application to combine bills for Verizon Wireless and Verizon Communication landline customers in Oracle 126.96.36.199 on SUN Solaris 2.8 through the Web GUI.
Reduced churn by 49% for both the landline and wireless customers, which directly translated into increased revenues and lowered costs; saved Verizon over $1 million since launch in July 2002.
Supported 3,000 enrollments per day with 2,000 representatives logging in the application to enroll customers.
Developed numerous PL/SQL packages, Stored-Procedures and Triggers, Views to support the application flow and business logic.
Developed and tuned SQL scripts for reporting purpose Maintained 6 oracle environments for ONE-BILL project.
Provide monthly database maintenance support on ONE-BILL application, which included new Tables, Views, Stored-Procedures and Triggers to enforce and maintain business rules.
Oracle DBA, Verizon.com Team Member Performed daily technical support, operations, and maintenance of Oracle databases (7x, 8x, 9x) in the E-Business.
Installed relational database systems software on database servers and administered Oracle databases for numerous applications on UNIX systems.
Created database instances, imported, and exported data.
Assisted with schema design and implementation to the development team.
Analyzed and optimized query performance, managed data space and administered users, monitored database instance, and set up data protection.
Configured new Oracle implementations for testing, development, and production environments; Designed and developed Oracle databases that support the registration, billing for Verizon.com Web site.
Set up scripts in PL/SQL and UNIX via SQL Loader and export/import utilities to load 140 million rows of data.
Wrote stored procedures and triggers to enforce business rules.
Setup snapshots and views for distributed database synchronization.
Increased performance by tuning SQL code, database parameters, and balanced I/O.
Developed and improve scripts in PL/SQL and UNIX shell scripts that modify database schemas import and export data.
Create scripts to extract, manipulate and modify data in tables across various schemas.
Developed scripts in PL/SQL and UNIX that backup, restore and recover database servers.
Tune application SQL, indexes, views etc, to meet performance objectives.
Determine storage and sizing parameters for tables and indexes for various projects.
Programmer/Analyst05/1998 to 05/1999Scientific Systems & Software International Corporation (SSSI)Columbia, MD
Developed and maintained a Small Business Disadvantage tracking system (SDB) for Small Business Administration (SBA) in Oracle 7.3.4.
Incorporated responses from the application in the Access database to Oracle database using UNIX scripts and SQL.
Developed and updated data models in Erwin; used SQL queries to update and modify data in Oracle databases.
Master of Science: Information Systems (MIS)1999University of BaltimoreBaltimore, MD
Information Systems (MIS)
MBA1998Kansas State University (KSU)Manhattan, KS
University of Baltimore
Bachelor of Science: Electrical EngineeringElectrical Engineering
Master of Business Administration: Information SystemsInformation Systems
Oracle 9i Certified Administrator (OCA)
*Oracle Database 12c: Backup and Recovery Workshop Ed 1
ASM, auditing, Automation, Backup, billing, Born Shell, Business Administration, C, capacity planning, com, Concept, customer satisfaction, data warehouse, Databases, Database, designing, disaster recovery, E-Business, Erwin, features, Firewall, GUI, HP, HP-UX, HP UX, Java, JDBC, Linux 4.0, Linux, Linux 4, Linux5, logging, logic, managing, mentor, Access database, Windows, 9x, MySQL, Enterprise, OCR, Operating system, Oracle 9.0.2, Oracle 9, Oracle Discoverer, Oracle Application Server, Oracle 7.3, Oracle, Oracle database, Oracle DBA, PL/SQL, Oracle and SQL, Oracle 7, Oracle 8, page, problem resolution, Project Lead, Quest, RDBMS, Red Hat, relational database, reporting, Sarbanes-Oxley, servers, scripts, Script, SUN Solaris 2.8, Sun Solaris 2.x, SQL, SQL Loader, switches, Symposium, Tables, technical support, TOAD, UNIX, UNIX shell scripts, UNIX scripts, upgrades, upgrading, upgrade, utilities, NetBackup, Web site