SUMMARY:

• Talented Database Administrator and Developer with solid background in programming and scripting.
• Worked well alone and as part of a team.
• Have strong communication and documentation skills. Have designed databases and schemas since 2006.
• Application Integration and Data Integration focused.

• Certified Confidential DB2 LUW and Oracle DBA
• Certified Confidential DB2 DBA v10.1 on z/OS
• Certified MySQL and Confidential Informix DBA
• Oracle SQL Expert (Oracle Certified)
• DB2 SQL Stored Procedure developer (Certified)
• DB2 Application Developer ( Confidential Certified)
• Confidential Rational Application Developer (Certified)
• Confidential Rational Application Tester (Certified)
• Oracle AIA Implementation Expert (OCE)
• DB2 Native Data Encryption
• Confidential InfoSphere Guardium experience
• Certified Confidential WAS Administrator
• Certified Confidential WMQ Administrator
• Certified Confidential WMB Administrator
• MS SQLServer DBA with Clustering
• NoSQL DBA - MongoDB
• OS and Database skills, NoSQL Admin
• Mentoring Java/J2EE/WAS/WMQ/WMB
• Global Security Kit (gsk7 and gsk8)
• Shell scripting (win & *nix) experience
• Strong analytical skills
• Comfortable with change, Fostering teamwork
• Database server optimization
• Excellence in Shell Scripting
• Excellent communication skills
• Database design, Data Modeling
• Excellent diagnostic skills

WORK EXPERIENCE:

MDM DB2 Database Specialist

Confidential

Responsibilities:

• Supporting InfoSphere Bidirectional Replication in MDM Enterprise HUB environment.
• Supported bi-weekly releases.
• Monitor and troubleshoot Q Replication
• Performed yearly DB2 vulnerability assessment reports and fixes
• Designed and implemented DB2 HADR/TSA auxiliary node failover script - korn shell.
• Prepare and run database packages in DEV, QA, PERF, PRE-PROD and PROD environments
• Investigated Data integrity and data security loop holes and prepared fixes.
• HUB Integration Services Engineering - CIF/OCIF/ECIF/MDM
• InfoSphere 9.7.9, WebSphere MQ 7.1, Confidential WebSphere Message Broker v7.0
• InfoSphere Master Data Management (MDM) - Advanced Edition, Collaborative Edition v 11.30
• InfoSphere DataStage ETL
• Deployment Services, Q Replication Problem Determination
• Bi-Weekly Implementations and Weekly Remediation patches.
• Deployment automation scripting.
• Designed HADR/TSA solution with 3 standbys in regular & restricted zones (2x4 DB2 servers).
• Solved QRep hang issue on stopping Q Capture and Q Apply threads.

Database Infrastructure Specialist

Confidential

Responsibilities:

• SQL Server 20%, Oracle 70%, DB2 10% production support. Most activities in Oracle, least in DB2.
• Enhanced MSSQL Server 2008 R2 log shipping and ROS. Added more application groups to use ROS for load-balancing purpose. This has eased up the load on OLTP up to 15%.
• SQL Server SQL implementations - developed PRS stored procedure for Archive, History and Delete functions.
• Enhanced DB2 and SQL Server database performance monitoring scripts.
• Oracle 11g R2 health-check scripting. Oracle DG Monitoring.
• Performed yearly vulnerability assessment reports and fixes of Oracle, DB2 and MSSQL
• Performance Tuning for DB2 and Oracle SQL, Applications.
• DB2 HADR and Enterprise Security. HADR Monitoring scripts in Windows.
• Production Support - Circulation as Primary and Backup DBA Resource.
• Rolling upgrades and Security patches.
• DR Testing SQL Server and DB2.
• Analyzing Locks and performance.
• Real time problem resolutions (MIRT).
• Created SBG’s, Implementation Guides and New Employee Onboarding Documents.

DB2 Database Specialist

Confidential

Responsibilities:

• Informix (IDS 11.5) to DB2 (v 10.5) transformation review before rollout.
• Performance Tuning. Python scripting for DB2 Performance test.
• DB2 Optimal Configuration Recommendations.
• Schema consolidation (Informix to DB2).
• Migration Scripting KSH Shell/SQL.
• UAT testing.
• Bash/KSH scripting, Data migration fixes.
• Migration Planning & Testing
• Analyzing Locks and performance.
• DB2 benchmarking and load-testing.

Confidential

System Administrator

Responsibilities:

• Websphere Commerce, WAS 7, MQ 7, DB2 v9.7, HADR TSA, Confidential WebSphere Message Broker v7.0, WSRR 7.5
• Websphere system and deployment automation with korn-shell and jython scripts.
• Weekly deployments.
• DB2 HADR (TSA) administration.
• GSKit: ‘at rest’ and ‘in flight’ data encryption - gsk7 and gsk8.
• Set up and run - Confidential InfoSphere Guardium - Implemented Fixes to Oracle, DB2, MySQL, MSSQL and WAS
• DB2 Native Encryption support
• One Fixpack (9.7.9a) upgrade.
• Confidential Data Studio, Control Center, db2top.
• DDL, DML and DCL implementations.
• Online and Offline Reorgs.
• PL/SQL batch processes, PL/SQL programs - Packages, Functions, Stored Procedures, Collections, Cursors, and Triggers.
• Installed EARs, WARs and configured application specific JVM settings, Web container parameters using the Admin Console and WSADMIN.
• Updated EARs for both Portal and Commerce servers.
• Wrote monitoring scripts, email and pager alerts.
• L2 DBA Support on Exercise DR Environment Restore.
• Handling SQL scripts run, LOAD scripts and Grant scripts requested via OTRS tickets.
• Created New Table Spaces for Table Backups. Used db2look for DDLs.
• Configured WebSphere resources like JVM heap settings, JDBC providers, JDBC data sources, connection pooling, Virtual Hosts,
• Performance Analysis using Confidential Tool-Kit.
• Analyzing Locks and performance using db2top and db2advis.
• AIX v6.1, DB2 UDB Enterprise Server Edition 9.7 (HADR).

DB2 Database Administrator

Confidential

Responsibilities:

• One major version upgrade (9.1 to 9.7).
• One Fixpack (9.7.8) upgrade.
• GSKit: ‘at rest’ and ‘in flight’ data encryption - gsk7 and gsk8.
• DB2 Native Encryption support
• Infosphere suite setup & support - DB2, DataStage, QualityStage and Information Analyzer
• Set up and run - Confidential InfoSphere Guardium - Implemented Fixes to Oracle, DB2, MySQL, MSSQL and WAS
• Two Disaster Recovery Exercises (lead one).
• NoSQL supported (MongoDB) - Database Administrator/Developer - COO (City Of Ottawa)
• NoSQL supported (MongoDB) – Database Administrator/Developer – MSC Direct
• One Real Disaster Recovery ( Confidential, Farmers and Nova teams)-disk failure.
• Work Load Manager (WLM), switching workload priorities.
• DB2 HADR (TSA) administration.
• Confidential Data Studio, Control Center, db2top.
• DDL, DML and DCL implementations.
• Online and Offline Reorgs.
• PL/SQL batch processes, PL/SQL programs - Packages, Functions, Stored Procedures, Collections, Cursors, and Triggers.
• Data Exports, custom export formats.
• Wrote monitoring scripts, email and pager alerts.
• Backup Weekly Prod and Non-Prod. Redirected Restore database and tablespace.
• Lead DBA Team on Exercise DR Environment Restore.
• Handling SQL scripts run, LOAD scripts and Grant scripts requested via OTRS tickets.
• Creating New Tablespaces for Table Backups. Used db2look for DDLs.
• Analyzing Locks and performance using db2top and db2advis.
• AIX v6.1, DB2 UDB InfoSphere Server 9.7 (DPF)

DB2 DBA/Developer

Confidential

Responsibilities:

• DB2 UDB z/OS version 8 and 10.1, CA RC Toolkit, QMF and ICETOOL
• Supported FATCA Development team
• Data Pre-Validation for initial loads
• COBOL Stored Procedures, SQL Triggers and JCL maintenance jobs
• Data validation for various development phases
• Handling data mapping for data load on data spec changes
• Analyze and implement data conversion strategies in DEV and PAT environments

Sr. DB2 Database Administrator

Confidential

Responsibilities:

• Complete InfoSphere component installation – Full env setup in 2012,2013.
• NoSQL supported (MongoDB) – Database Administrator/Developer – COO (City Of Ottawa)
• NoSQL supported (MongoDB) – Database Administrator/Developer – MSC Direct
• Work Load Manager (WLM)
• DB2 UDB HADR database setup
• Data Pre-Validation for Solution Design
• Data validation for various development phases
• Data transformation handling through multi staged environments
• Extensively experience of PL/SQL batch processes, PL/SQL programs - Packages, Functions, Stored Procedures, Collections, Cursors, and Triggers.
• Extensively worked on data validations and profiling
• Experience of interfacing extensively with the Business Teams for requirements mapping, cause analysis or defect resolution
• Handling data mapping for data load on data spec changes
• Wrote scripts to transfer data from database to excel or flat files and used SQL Loader to load data from excel or flat files to data base.
• Performed quality check/ Data analysis on data coming from different sources.
• Analyze and implement data conversion strategies in DEV and PAT environments
• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users
• Closely went through and worked on all the stages of the project and executed Functional, Integration, Regression, and System (End to End), Backend (Database) from a Data perspective
• AIX v6.1, DB2 UDB InfoSphere Server 9.5 (DPF)
• Supported LBAC access control on warehouse server
• Using DB2 UDB 9.7 new index compress features to save disk space on large tables
• DB2 UDB porting from AIX to Centos
• DB2 UDB development and production support on LINUX/AIX/Windows
• DB2 UDB database cloning using REDIRECT restore and DB2 UDB relocatedb
• Production databases troubleshooting production issues
• Used DB2 UDB Health Monitor and testing Confidential Data studio for DB2 UDB database monitoring
• Using Confidential InfoSphere Architect (IDA) for data model and generating DDL
• DB2 UDB V9.1 upgrade to DB2 UDB V9.7
• Supported ORACLE 11g servers for City Of Ottawa
• Managed DB2 Security using OS group and user ID, DB Authentication, DB Authorization, and database object privileges
• Managed DB2 LBAC security policies.

Principal Consultant

Confidential

Responsibilities:

• Developed over 35 stored procedures for various OLTP and OLAP requirements.
• Entity Design & optimization, SQL optimization support for Java Programming Team. Used Erwin Data Modeler and InfoSphere Data Architect for modeling data for new add-ins to existing databases. Re-evaluated about 120 data units.
• Informatica ETL, PowerCenter 8.6
• Understood the end-to-end scope of work and designed architectural solutions accordingly. Used database design guidelines and database modeling concepts to ensure data accessibility and security. Develop plans, strategies and standards for data within the enterprise.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the process.
• Identified Entities, attributes and relationships and designed the conceptual, logical and physical model using ERwin Data Modeler & Confidential Rational/InfoSphere Data Architect tool. Designed star & snowflake schemas.
• Involved in meetings with Business Analyst’s & BI's at Shoppers Drug Mart and made proper database modeling decisions accordingly. Partner with all other teams (database management team, software development team ) and UAT testers to provide best solutions by maintaining the best standards of practice.
• Ensured that all information requirements in the Business Architecture were met at the time of delivery and produced good quality of work products and delivered database models as per schedule.
• Planned and migrated ERwin data models to Confidential Rational modeling tool (IDA) and resolved many incompatibilities between the two tools.
• Followed-up with team members on the installation, connectivity and access issues for software’s with Shoppers Managers and gained required access on time.
• Conducted status calls with resources in Alberta (Calgary) and Nova Scotia (Halifax) and maintained smooth communication within the team.
• Provided guidelines to resolve queries and issues faced by team members.
• Implemented OLTP, ODS, EDW concepts
• Designed Extraction Transformation Staging Loading workflows
• Resolved workflow slowness issues, provided various development routines.
• Used Infomatica PowerCentre 8 & 9 for workflow development.
• Assisted the team with persistence and business logic development
• SP/Trigger and SQL tune-up. Facilitated SQL optimization for 30 Informix Databases.
• Informix (IDS) versions 7, 9 and 10 on AIX 6.1 and 5.
• DB2 UDB and Informix Database Monitor Development
• Review Current practices – Recommend improvements
• 24 DB2 UDB v9.1 instances on 17 physical servers
• One DB2 UDB warehouse with 16+1 partitions
• Devise and implement Capacity Management Procedures
• Max size 1.6 TB - DPF (16 partitions on 3 physical servers) - Dimensional
• Programmed in pure Korn Shell scripts. Developed full Pro-Active Monitoring Model for DB2 UDB and Informix Databases.
• Developed DB2 UDB korn shell Performance and Capacity Management application.
• Developed Delayed Alert system using Open View and Remedy interfaces.
• Informix IDS (versions 7.3 - 10) korn shell script application was developed on the same business logic.
• Identified Entities, attributes and relationships in physical model using Erwin Data Modeler & Toad Data Modeler and prepared recommendations based on best practices of data modeling.
• Reverse engineered existing production databases (some that involved in development projects) using MS Visio.
• Analyzed data type usages for various indexing strategies and performed an expert check on performance per data model.

Database Administrator

Confidential

Responsibilities:

• Team Lead - team of 5 - New Databases designed - 3 databases - 14 data model sets (schemas).
• Tools used ER/Studio, AQUA Data Studio, PowerDesigner, MS Visio and Toad Data Modeler.
• Upgraded 5 Windows servers to BSD Linux v8. Initial loads and regression tested. ETL via custom scripts - From Windows DB2 UDB databases to newly developed DB2 Databases on BSD Linux v8.
• Performance Tuned SQL Server engine and SQL Queries.
• Developed Stored Procedures, Triggers and batch scripts.
• Scripted new implementations for Customized Health Monitoring Alerts.
• OLTP performance monitoring using windows scripting was implemented using 5 scripts and 3 datafiles.
• Performed Logical Design to Physical Design (Oracle and DB2 UDB Databases), Database Entities Performance testing/tuning, PL/SQL programming and SQL Tune up.
• Setup and maintained Q-Replication (QREP).
• Reverse engineered existing production databases (some that involved in development projects) using MS Visio.
• Generated detailed ERD layouts of existing Data Models with Aqua Data Studio.
• Identified Entities, attributes and relationships and designed the conceptual, logical and physical model using ERWin Data Modeler, PowerDesigner & Toad Data Modeler. Designed star & snowflake schemas.
• Involved in meetings with Business Analysts’ and Java Development Team and made proper database modeling decisions accordingly. Partner with all other teams (database management team, software development team, designers) and users to provide best solutions by maintaining the best standards of practice.
• Documented source and target data mappings and validated the models to ensure it supported the principles, objectives and constraints.
• Reviewed the qualitative criteria, providing all the measurable criteria (e.g. minimum tolerable data losses, maximum data volumes at peak times).
• Ensured that all information requirements in the Business Architecture were met at the time of delivery and produced good quality of work products and delivered database models as per schedule.
• Implemented efficient databases, including specifying physical characteristics, designing efficient indexes and mapping database objects to physical storage devices.
• Performed traditional physical DBA tasks such as problem determination and resolution, performance monitoring and tuning using snapshot functions, identifying problem SQL and performance bottlenecks, schema changes, configuration changes, working with developers and explaining analysis.
• Developed DB2 UDB database schemas for new game development projects.
• Responsible for managing Mirror Nightly Restore system scripts for all production databases.
• Developed, installed and managed DB2 UDB stored procedures for various purposes including daily reporting & batch prune large tables.
• Opened PMR with Confidential Software support and assisted with new issues troubleshooting.
• Developed monitoring & preventive scripts for DB issues on various problems (Held Logs Monitor, Table Lock Monitor, Force Bad Apps).
• Developed regular DBA monitoring scripts (TableSpace Watch, Diaglog Monitor Alerts, Server Disk and Process Monitor).
• Tested and recommended DB2 UDB implementations w.r.t encryption devices.
• Tested and reported 3+ bugs to Confidential support, obtained hot fixes and applied to production databases.
• Provided 24*7 support via pager, cell phone, VPN.
• Developed trigger and SProc fine tuning strategies.
• Prepared and implemented audit routines as per industry and organization standards.
• Applied various fix packs and patches for DB2 UDB.
• Developed and implemented DB2 UDB backup & recovery processes.

Lead Database Administrator

Confidential

Responsibilities:

• New design and experiment existing for performance. Used Erwin, Toad Data Modeler, PowerDesigner MS Visio for Data Modeling Support.
• Developed (designed) databases for Linux platform, written required scripts for maintenance. MySQL ver 5.0 on CentOS 4.8.
• Developed databases in DB2 UDB & MSSQL. Also all scripts and scheduled jobs were written. Windows environment.
• Closely worked with software development teams and database administrators at various sites reviewing logical/physical data models. Worked on Data Models and trained client development teams on understanding data models.
• Responsible for managing over 150+ servers, 600+ application clients (Windows, AIX, Solaris, Linux), 450+ instances, 650+ databases and over 10,000 end users
• Develop, install and manage relational Database Management Systems utilizing DB2 UDB, Oracle and SQL Server on various versions, editions and operating system environments
• Provide 24*7 support via on-call (pager, cell phone)
• Prepare and implement audit routine for all the RDBMS as per industry and organization standard
• Apply various fix packs and patches for DB2 UDB.
• Develop and implement DB2 UDB backup, Oracle RMAN backup and SQL Server backup and recovery processes
• Improve database performance via. fine-tuning queries, change database parameters, change operating system parameters
• Create various database objects e.g. buffer pools, table spaces, tables, indexes, functions, federated objects – wrappers, servers, user mappings, nickname etc.
• Create and tune MQT’s and MDC’s for analytical purposes
• Diagnose database log and event log files on daily basis to identify/fix errors
• Setup backup and recovery processes for all the databases using TSM
• Participate in DR testing by creating the process documentation and performing on-site recovery
• Cleanup old servers from DB2 UDB, Oracle and SQL Servers components e.g. code, instances, databases, file systems and ID’s
• Develop customized scripts for data refresh, replication and other solution for specific business solutions
• Developed various customized scripts e.g. to track database activity, track transaction logging, tablespace usage, cleanup old database images and logs from TSM etc.
• Create and implement best practices for DB2 UDB HADR, backup/recovery, performance tuning etc.
• Open PMR with DB2 UDB support and assist with new issues troubleshooting
• Administer and tune database on daily basis, running utilities like – Reorg, Runstats, event analyzer, event monitor, import, export, load, analyze etc. on various RDBMS’s

Database Administrator

Confidential

Responsibilities:

• Performed different tasks in UNIX related to DB2 UDB i.e. user creation/update, file system update, Organizing files and directories, installing software
• Developed, installed and managed relational Database Management System, utilizing DB2 UDB v7 and v8 in Windows environment
• Managed databases with size in excess of 300 GB. Create processes to take bi-weekly database backups, restore, import/export etc.
• Improved database performance via. fine-tuning queries, change database parameters, change operating system parameters
• Diagnosed database log and event log files on daily basis to identify/fix errors
• Administered and tuned database on daily basis, running utilities like - reorg, event analyzer, event monitor, import, export, load
• Provided 24*7 support
• Interfaced with business analysts to perform needs analysis and define user specifications
• Analyzed user/business requirements and translate into functional specifications
• Design storyboard prototype designs for database applications
• Created and implemented SQL-based procedures, including writing stored procedures, scripts, User defined functions and Data Types
• Designed Instances, databases and schemas
• Designed, created and implemented primary database storage structures (table spaces) and primary objects (tables, views, indexes, triggers, constraints)
• Documented daily jobs performed on the database, troubleshooting connectivity issues

Oracle Database Administrator

Confidential

Responsibilities:

• Used Explain Plan and Oracle optimizer hints to enhance performance of SQL statements.
• Performed the user requirements and troubleshooting activities and resolved connectivity issues.
• Implemented, administrated, and maintained daily backup and archived data on tape.
• Created user accounts and system-level and user-level database objects.
• Daily Database Monitoring - database disk and memory usage.
• Stored Procedures, Triggers and SQL/Shell scripts.