DBA Expertise

• Twenty-Five years of experience in IT as a Database Administrator, Data Architect/Designer, Data Analyst and Data Engineer.
• Expert level of DBA skills in managing multi-partition and multi-terabyte DB2/UDB 11.5/10.5 databases for fortune 50 companies.
• Highly experienced in upgrade, installation, configuration, backup/recovery, maintenance and support of DB2/UDB instances and databases.
• Proven ability to create, administrate, and migrate; and effectively performance tune over 300 databases; on a 24X7 basis in High Availability Disaster Recovery (HADR) environments; for OLTP and Data Warehouse applications.
• Proficient in designing, developing and implementing; multi-terabyte Business Intelligent Data Warehouse and Data Mart Systems.
• Created databases, table spaces, tables, views and stored procedures in development, testing and Production environments.
• Designed and Implemented company’s security policies to secure data and databases from unauthorized access.
• Designed and developed DB2 Federated objects with heterogeneous data sources from different databases (Oracle, DB2 and SQL Server) to support data migration to DB2/UDB databases.
• Excellent expertise in database logical and physical relational and dimensional modeling using ERwin.
• Analyzed user requirements to design normalized data model and star schema model to implement Data Warehouse and Data Mart.
• Administered and monitored the DB2/UDB databases and instances using Crontab and UNIX scripts.
• Designed and developed UNIX shell scripts to proactively monitor multiple databases, schedule regular database backups and other database maintenance jobs.
• Provided Level 3 24/7 on-call support on rotating pager schedule.
• Two years of database manager experience supervised a team of ten DBAs and database developers: working on multiple database projects on multiple platforms Oracle, DB2/UDB, Sybase, SQL Server.
• Mentored and trained junior DBAs, ETL and BI report’s developers to code effective queries.
• Designed and developed semi-automated redirect-restore script to support development and testing activities between test and production databases.

      Database Tuning Experience 

•  Proven performance tuning skills in database designing, implementation and post deployment.
• Effectively Improved ETL jobs and BI report’s performance by 50-90% by tuning SQLs and adding COLUMNAR Tables, MDCs, MQTs, indexes and compressed large tables. 
• Analyzed, designed and optimized database physical model by creating appropriate MDCs; selecting effective hash partitioning columns to equally balance data across database partitions.
• Improved the performance of the SQLs with Star Schema joins by adding Replicated Tables on Reference and Dimension tables.

      ETL Experience 

• Designed and implemented ETL job using Apache Spark/Scala/Python.
• Designed and developed Informatica’s workflows to load data from mainframe and flat files to DB2/UDB databases.
• Wrote Shell scripts to move high volume data from different database sources to target Db2 database using IBM Migration Utility.

     Soft Skills

• Documented and deployed the database release changes using version control system.
• Excellent verbal and written communication skills, including vendor communication to resolve database defects, collaboration with infrastructure teams and customer communication.
• Very strong analytical, problem solving and technical skills.
• Proven performance tuning skills in database designing, implementation and post deployment.
• ffectively Improved ETL jobs and BI report’s performance by 50-90% by tuning SQLs and adding COLUMNAR Tables, MDCs, MQTs, indexes and compressed large tables. 
• Analyzed, designed and optimized database physical model by creating appropriate MDCs; selecting effective hash partitioning columns to equally balance data across database partitions.
• Improved the performance of the SQLs with Star Schema joins by adding Replicated Tables on Reference and Dimension tables.