SUMMARY:

• A highly qualified, goal - oriented information technology professional with 12+ years extensive experience in DB2 UDB Database Administration, Database Architect with OLTP and Data Warehouse systems, Application development life cycle methodologies, Database and Application performance tuning, Implementing High Availability options using Data Guard with Zero Data Loss, Oracle 10g RAC and Advanced Replication in OLTP environment.
• Possesses a proven ability to streamline processes and coordinate efforts between diverse groups.
• An adaptable leader rapidly learns new technologies and stays abreast of trends in the industry to place the company at the forefront of technology and increase productivity and profitability. Responsible for Single spiral development of databases and database applications, database development and maintenance, analyze new database technologies and integrate into existing systems, perform database performance and functional testing prepare and peer review documentation, i.e. Software Requirements Specifications, Design Documents, Test Plans, Code Reviews and Trade Studies, etc.
• Developer of internal and external performance management dashboards enabling business intelligence reporting including benchmarking, metric identification, performance measurement, and target setting.
• Provided technical guidance to customers and team members, lead various database and application development efforts using the SCRUM agile software development method. DB2/UDB Oracle DBA for Confidential of Citizenship and Immigration Services
• Responsible for implementing multiple DB2 versions 9x databases repository/data store supporting a Tivoli Storage Server, LDAP Tivoli Identity Manager Environment, responsible for backup, test recovery, LDAP level replication for high availability user-managed environment.
• Configured Tivoli Storage Manager (TSM) for advanced backup tape storage for databases, gather technical specifics, considered monitoring tools (DB2 Data Studio, Control Center and Oracle Grid Control 11g) for proactive maintenance

WORK EXPERIENCE:

DB2 DBA - Consultant

Confidential, Herndon, VA

Environment: AIX 7.1 and SLES 10.4/11.2

Database Server: DB2 on Linux, UNIX and Windows 8.2, 9.7, 10.1 and 10.5Other Products PostgreSQL 9.3.4, SQL Server 2012 and HP Vertica

Responsibilities:

• DB2 Database Upgrade from DB2 9.1 to DB2 10.1.HA and DR Implementation using multiple standby's across two data centers.
• Monitoring and Alerting system implementation.Training the available DBA's on DB2 LUW.
• Implementing multi-temperature storage architecture.Backup and Restore Process Implementation.
• Proactively monitor server and database process health to ensure availability and performance.
• Implement proactive capacity planning processes.
• Automate the DBA maintenance process including BACKUP, RESTORE, RUNSTATS and REORG.

DB2 UDB DBA - SAP DBA

Confidential, Reston, VA

Environment: BCU D5100, ISAS 5600, Siebel/OBIEE, AIX 7.1, SLES 11 and SAP ECC 6

Database Server: DB2 65 Data Partitions (DPF), SQL Server 2012, Oracle 11g, Netezza and SAP HANA

Other Products: Confidential Information Server 8.7, Confidential Cognos 10, Confidential Infosphere, Informatica, SAP BW Pack

Responsibilities:

• DB2 Balance Warehouse D5100 and Smart Analytic Systems ISAS 5600 V2 solution design,implementation and deployment.
• Collaborate with Technical Project Services Group to deliver comprehensive database solutionssupporting business functions, OLTP systems, Information Integration, Data Marts and otherenterprise data stores.
• Participate with Competency Center Leads to implement tactical DBMS infrastructure,architecture solutions, leveraging the DBMS platform, DBA productivity tools, DBMS utilities,database monitoring, database connectivity, and DBMS access tools.Be the DB2 principal among Enterprise Architecture, Application Development and Operations in Information Systems on system inter-operability issues.Designing MDC, MQT, Hash Partitioning Keys on DB2 Advanced Enterprise Editions.
• Work with Competency Centers to promote changes to production.Attend internal database design reviews with Competency Centers to ensure adherence to established standards and best practices.
• Perform all of the relevant database activities in a safe and responsible manner and support allEnvironmental, Health, Safety & Security requirements and programs.
• Participates in design, development and implementation of DB2 database across SAPdevelopment, QAS and Production landscape along with HP and RB SAP teams.Performing DB2 database administration through DBACockpit and SAP HANA through SAPHANA Studio.Monitoring DB2 SAP Systems with SAP Solution Manager and using db2pd, db2cklog,db2diag, db6util, db6conv and db2support tools for troubleshooting.Design, Deploy and Support new SQL Server Cluster environments.
• Perform capacity planning and performance tuning across all the database platforms.Deploy, Configure and Support Monitoring and Alerting Utilities.
• Effectively performing database consolidation and migrations13 DB2 9.1, 9.5 to DB2 9.73 DB2 9.5 D5100 Balanced Warehouse systems (41 logical partitions) to 3 DB2 9.7
• ISAS 5600 Confidential Smart Analytics System (65 logical partitions)237 SQL Server 2000 instances to SQL Server 20088 SQL Server 2005 instances to 4 SQL Server 2012Oracle 9i to Oracle 11gInstall, Configure and Migrate Confidential InfoSphere Information Server Data Stage and Quality
• Stage 8.7.Help finding the runtime aspects of InfoSphere DataStage jobs using Services Director. Netezza TwinFin 12 Data Mart Implementation for Management Reporting

Lead DB2 Database Administrator

Confidential, Benckiser, MD

Environment: BCU D5100, Siebel/OBIEE, AIX 5.3 and SLES 10

Database Server: DB2 41 Data Partitions (DPF), SQL Server and Oracle 11gOther Products: Confidential Information Server 8.1 and Confidential Cognos 10

Responsibilities:

• Install, Configure and validate DB2 across various critical environment including DB2 on Confidential Balance Warehouse D5100.
• Proactively monitor server and database process health to ensure availability and performance,security management and user provisioning.
• Support DB2 High Availability and Disaster Recovery (HADR) solutions using Confidential TivoliSystem Automation (TSA) for Siebel and OBIEE.
• Automate DBA processes and create shell and Perl scripts to streamline and improveefficiency.
• Support product development and test teams through SDLC process.
• Manage individual workloads and customer expectations.
• Participate in on-call DBA support and provide off-hours production deployment support.

DB2 UDB Database Administrator

Confidential, Vienna, VA

Responsibilities:

• Supported multi-terabyte databases on db2 V8 on AIX(p570) with SQL replication as the redundant solution.
• Performed database installations, migrations and upgrades for v8.x, 9.1 and 9.5. Ran DB2 utilities like REORG(offline & online), RUNSTATS, REORGCHK, REBIND for Database maintenance. Experience with setting up, supporting and troubleshooting HADR.
• Provided consultation to application development teams on DBMS product technical issues, techniques and SQL review.
• Experience with SQL tuning and analysis.
• Coordinated with system engineers to configure servers for DBMS product installation and complex database creation.
• Performed database related optimization, diagnose system bottlenecks and application related bottlenecks.
• Served as resource for database server consolidations project, collapsing multiple database servers to form large SMP environment.
• Created and maintained UDB DDL for databases, table spaces, tables, views, triggers, and stored procedures.
• Resolved lock escalations, lock-waits and deadlocks.
• Established, maintained, troubleshot SQL Replication.
• Worked with TSM and VERITAS net backups.
• Experience with financial and travel data.

Senior Database Administrator

Confidential

Environment: Siebel and Siebel Analytics

OS: AIX 5.3 ML 05

Database Server: DB2 UDB 8.2, DB2 v9.x

Other Products: SQL Server 2005, I manage, magic, Infra, Oracle, Share Point, and Java Script

Responsibilities:

• DB2 Database production support technical team member.
• Debugging database failures and resolving them in a time frame.
• Work closely with development team in designing the databases for SIEBEL Applications.
• Co-ordinate between partner USA teams for day to day workDB2 performance tuning.
• DB2 Monitoring and Alerting System Implementation.Database memory tuning for SIEBEL applications.
• Building the new database maintenance plans (REORG, RUNSTATS and BACKUP) and the jobs using shell script.Building the lock monitoring tool using the shell script on DB2 v8.2.Building the automatic restore script generation tool using perl.Building the database standards across DB2 environment and documenting it.
• Week end support for major application deployments such as Account Segmentation, Master
• Data Management projects.Working with Confidential on PMR's raised by India and USA teams.Implementing HADR and HACMP solutions for Siebel.

Senior DB2 Database Administrator

Confidential - Reston, VA

Responsibilities:

• Full scope database administration functions; monitoring, tuning, problem resolution, object sizing.BMC tool installation and maintenance. Confidential Data Propagator installation.
• Maintained database authorizations defined via CA RC/SECURE.
• Defined and maintained dynamic sql Resource Limit Facility specifications.
• Application and tool database reorganizations.Local and disaster application backup and recovery.CA Detector, PlanAnalyzer, RC/SECURE product upgrades.As CA RC/SECURE administrator, performed all standard DB2 authority updates.
• Establishment of BMC LogMaster log backout table recovery.
• Enablement of stored procedure builder functionality.
• Assisted with DB2 V7 and V8 migrations.Responsible for all V8 BMC tool compatibility migration.
• Some notable achievements:Implemented first use of online reorganization for the system catalog, which significantly decreased outage time, and allowed for more frequent reorgs and decreased dasd.
• Lead administrator for project which implemented first direct internet based application client interoperability with Z/OS DB2.

Db2UDB DBA

Confidential

Environment: Euclid

OS: Sun Solaris and Linux

Database Server: DB2 UDB 8.2/ DB2 9.1 Data Servers

Other Products: Websphere MQ, HPOV, iWatch, Autosys, DBArtisan

Responsibilities:

• Install, Configure and Validate DB2 on development, UAT and Production systems.
• Implementing PAM, Kerberos and Auth Servers across the DB2 environments.
• Debugging database failures and resolving them in a time frame.
• Work closely with development teams in designing the databases and Q replication between the sites.
• Work closely with partner labs on Kerberos security features.
• Co-ordinate between partner labs to follow sun support model DB2 performance tuning and DB2 Q-Replication implementation.
• DB2 Q replication setup and maintenance Database migration from Sun Solaris 5.8 to sun Solaris 5.10.
• Implement automated database maintenance jobs using Autosys.
• Participate in on-call DBA support and provide off-hours production deployment support.

System Software Engineer

Confidential

Environment: DB2 Development

OS: AIX, Linux

Database Server: DB2 UDB 8.1, DB2 9.1 and DB2 9.5

Other Products: NDS, Volubill charging system, Shell and Perl Scripts.

Responsibilities:

• Benchmarking of Apertio's One-NDS application on Confidential hardware was performed using LS 21 DualCore Opteron, HS 21 Dual Core Xeon and HS 21 Quad Core Xeon x86 servers running SLES 9.Worked on NDS and Volubill performance test case design and development.
• The performance test has been accomplished on the production machine in SDP Confidential location.
• Thetest results displayed are based on the testing tool (SLAMD) results.
• Most of the test results are based on 8 DSA setup.Performance benchmarking of Apertio's One-NDS application on Confidential hardware was performed on the
• Production environment for the Confidential SDP. Various tests were performed, testing read, modify, update,load and HA operations, to benchmarked the performance in each caseWorked on test strategy, test cases, and test environment implemented for Confidential SDP charging system performance test.
• Develop and enhance DB2 UDB v9.5 samples in different languages.To propose technical data needed to be included in the documentation of new features of DB2.To enhance the features of DB2 UDB, interacting with developer and DB2 source code and exhibit the features in a sample program.
• Develop the test cases for MDC Rollout solution and coding the test cases in perl/clp.Running the complete set of table partitioning test cases to make sure the feature works properly.Upon DB2 crash, analyze why it has crashed and investigate further in the source code to seewhich line is failing and the reason for the failure.Closely interact with DB2 product developers to provide the fix for the problem.