OBJECTIVE

• Seeking senior level managerial assignments in Database Administration wif a reputed organization in IT industry and put my maximum efforts for teh growth of teh organization and myself.

SUMMARY

• IBM Certified DB2 UDB Database Administrator wif around 10.5 years of expertise in DB2 Database Administration, MS - SQL Database Administration and IBM InfoSphere Data Stage Administration
• Extensive experience in Administration, query analysis, optimization, migration, up-gradation, troubleshooting, capacity planning, backup & recovery for ensuring business continuity, security management.
• Conversant wif Backup & Recovery Techniques, Performance Tuning.
• Deft in setting up & maintaining teh high-availability for mission critical environments using OS Cluster Software, Data Guard, DB2 HADR and various replication software's like DBTS. SQL server replication.
• Expertise in DB2 Database Administration activities encompassing database planning & design, installation/ configuration of DB2 software, server monitoring, security implementation, database up-gradation & migrations, troubleshooting on AIX, SUN OS, Linux & Windows platforms, etc.
• Well versed wif concepts of DB2 UDB, Oracle, MS SQL and Sybase databases.
• Gained significant exposure of working on DB2 UDB for AIX / Sun OS/ Linux & Windows Environment.
• Excellent communication & interpersonal skills wif strong analytical, problem solving and organizational abilities.
• Handling end to end project management activities inclusive of database planning, effort, design, scope, estimation, resource coordination and delivery as per specified timeframes.
• Monitoring project progress as per scheduled deadlines for various tasks and taking necessary steps to ensure completion wifin time, cost and effort parameters.
• Leading & managing project teams throughout teh project lifecycle and providing them support & guidance on technical and project-related issues.
• Managing code deployment, change/process management, quality assurance and documentation.
• Providing technical support to application development teams and setting / maintaining standards
• TEMPEffectively providing database support to teh customer sites that are having mission critical business environments.
• Involve in performance testing, user acceptance testing & extending post go-live support, including training support to end-users.
• Installing, configuring and up-grading DB2, MS SQL database Software wif High Availability futures.
• Experience in administer teh mission critical OLTP, business Data warehouse and DSS environments wif size of 5 TB.
• Savvy wif H/A features like, DB2 HADR and Disaster Recovery including DB2 mirroring wif flash, MS-SQL Mirroring also replication tech noledge's like, SQL replication and DBTS (now MIMIX share)
• Planning, implementing and review teh backup & recovery procedures of all databases to make sure less impact on business and ultrafast recovery for mission critical business environments.
• Involved in fine-tuning teh database in all aspects, database monitoring, maintenance, troubleshooting, database backup, recovery & DR activities and extending support to technical teams for optimizing application performance.
• Set up teh DPF and non-DPF environments for Data warehouse & OLTP systems, Creating, managing Standalone/Partition Instances & databases and implementing teh database build standers for managing teh high volume of databases.
• Monitoring server events & database health using enterprise monitoring agent/our homegrown scripts for to monitor DB heartbeat, Tablespaces threshold, checking alert logs, backup logs, etc.
• Handling user and profile creation set-ups, user rights & security management activities for DB2, SQL server and Oracle database.
• Overseeing application system administration involving creation of users, responsibility, roles; setting teh profile options and managing teh workflows & segregation teh responsibilities, etc.
• Expertise in Horizontal and Vertical sizing of Business Objects environments for BOXI 3.1/BI 4.0/4.1. Design and implementation Business Objects XIR3, BI 4.0 systems. (end to end involvement like requirement gathering, planning, installing, SP Upgrade and testing)
• Administer ETL server (DataStage) as part of Database support to ensure connectivity between all source and targets databases as per teh business need.
• Experience on database support transition projects and quickly transfer services to IBM internal global teams or take over services from external customer venders to IBM.

TECHNICAL SKILLS

Operating Systems: AIX, LINUX, SUN OS, WINDOWS, OS/390

Programming Language: COBOL, JCL, C, C++

Database: DB2 LUW, Oracle, Sybase and MS-SQL

Reporting and ETL Tools: BoXi 3.1, BI v4.0, BI v4.1, v4.2 and DataStage v8.1, v11.1

Middleware: WAS, MQ, JBOSS EAP and Tomcat

Scripting: UNIX Shell Scripting.

Service & process tools: Maximo, SCCD, ICD and SNOW.

Monitoring tools: Tivoli and HP Sitescope. (SIS)

Backup and recovery tools: TSM, Net backup and EMC Networker (Legato). VM Snapshots and cloning.

Password vault tools: Cyber Arc and TPAM.

Replication tools: Double-Take SHARE, SQL replication and HADR, Q replication.

PROFESSIONAL EXPERIENCE

Confidential

Sr DBA and onsite DBA

Responsibilities:

• Serving as an onsite DBA SME to support customer critical databases which include public facing OLTP and DWH environments (DPF) wif size of 10 TB as a part of BAU Support Team.
• Handling end to end database projects which includes requirement gating, provide db related solutions and suggestions, technical review of project plans & infra designs.
• As a DBA focal, co-ordination wif offshore team for all BAU related matters and escalations.
• Provide technical support for all database related issues and do a quick and timely resolutions to minimize teh impact
• Create and manage database build standards for easy, uniform maintenance and administrations.
• Deploy IBM global health check standards and remediate non-compliance issues to manage DB security compliance score.
• Upgrade DB2 and SQL Server databases based on teh project and application requirements.
• Conducting weekly status meeting wif offshore DBA team to review incident, problem tickets, RCA reports, fallow-up on all open list of activities to prepare and upload management reports accordingly.
• Review all major change request plans, assists on teh database and infra related activities, participated in CAB and transition meetings for business impact analysis, approval of application and database changes into production environments
• Automate teh DBA task like backups, Reorgs, Runstats, capacity monitoring, moving teh diaglog files, monitoring teh size of teh table spaces by setting up a threshold etc.,
• Migrate large DWH databases from DB2 v9.7, v10.1 on AIX databases to v10.5 databases on Linux wif minimal business impact to support customer future business directions like virtualization and cloud databases.
• Support assistance for nightly batch jobs and make sure that all jobs would be complete wif agreed SLAs windows.
• Monitored database performance wif respect to Memory, CPU Utilization and IO bottlenecks for multiple workloads and performed database tuning to handle growing requirements.
• Performed root cause analysis on DB2 databases, application and system related problems.
• Resolved critical production problems and provided 24x7 production on call support on a rotating basis.
• Monitored long running SQLs on a routine basis and performed query tuning to improve overall performance
• Followed incident, problem and change management principles and best practices.
• Applied fix packs routinely as part of IBM Patch management process (CIRATS) and configured DB2 UDB on Unix/Linux and Windows environment.
• Planning, Design, configure and implement crass database replication from AS 400 to Oracle, DB2 and Sybase databases wif halp of Double-Take SHARE tool. (aka MiMix share) Manage real time replication between host and peripheral databases to support as per teh business need.

Confidential

Sr. DBA Specialist

Responsibilities:

• Serving as database administer for teh mission critical OLTP, OLTP & data warehouse environments (DPF) wif size of 10 TB as a part of BAU Support Team
• Well versed and hands on experience on Oracle, DB2, Sybase and MS-SQL database patching and up-gradation activities.
• Database Installation, configure teh database, setup HA, patch installation, commission and decommission teh databases.
• Looking end to end components for Oracle, DB2, Sybase and MS-SQL databases, BOXI and DataStage Sub-systems during ETL related issues.
• Managing teh implementation of change requests wif halp of change management process and incidents wif incident management process
• Providing database support coverage on basis of 24/7 approach to handle all type of database support matters.
• Handling teh DR drill exercises & implementing teh disaster recovery procedures to ensure that database is available at all times and make review of DRP procedures based on SAL’s and do teh necessary changes on periodical basis to ensure teh recovery.
• Creating and Implementing teh IAM user roles, define teh responsibilities and provide assistance on user related queries.
• Writing adhuc SQL Scripts & DDLs for Data Warehouse and DSS Environment to assists on application support teams.
• Checking teh databases, capture teh SQLs response time and generate reports; identifying teh bottlenecks and perform teh necessary performance tuning on all levels on an ongoing process.
• Automate teh DBA jobs for backups, Reorgs, Runstats, Space & capacity monitoring, moving teh diag log files, monitoring teh size of teh table spaces by setting up a threshold (75%) etc.,
• Working wif Enterprise monitoring tools to monitor teh database and also write our own scripts which are used to monitor teh database & instance availability, orphan ids, applications connectivity count, db2diag.log, etc. for all stand alone and partition database environments
• Overseeing teh DB Governor monitoring scripts and assigning teh policies
• Conducting teh regular DB health check, audit checks, QEV, PRV, CBN and other corporate process as a periodic cycle’s basis for all teh databases
• Checking and implementing teh up-gradation of all applicable DB2 and Oracle Database to install teh new patches as part of IBM CIRATS compliance process.
• Upgrade Oracle 11G databases to Oracle 12c databases and DB2 9.7 databases to 10.1/10.5 wif a latest patch.
• Unix Shell scripts to automate teh Oracle hot backups, RMAN, export and import of database requests.
• Assisting application development teams during teh tech refresh projects to plan and minimize less impacted downtime
• Implementing teh ID Management Process (System Access) to follow teh corporate security polices, process and standards to avoid/prevent teh un-authorized data access.
• Performing periodic capacity planning and implementing required changes in teh database, BO & Data Stage Servers, etc.
• Implement teh database refresh from production environment to other environments.
• Taking databases backup, archive logs wif halp of Enterprise Backup Solutions like HP Networker, TSM and Net Backup Servers to make teh up to date recovery of teh database during incidents.
• Imparting training to developers and operations staff on frequent issues resolution procedures to reduce teh support calls.
• Rapid upgrading of MS-SQL 2005 databases to 2012 for mission critical databases for minimal downtime.
• Involve Design, implement and practice database password vault process wif using of Cyber Arc and TPAM.
• Implement and initialize DB2 HADR replication wif multiple read standby databases to replicate database to different sites.
• Responsible for SAP business objects administration for facilitating various reports generation for business needs.

Confidential

DBA Specialist (DB2 Database)

Responsibilities:

• Worked as a Member of Bank Core DBAs BAU 24/7 Support Team and involved in administering teh large volume of databases including production, SIT, UAT and DR DB2 Databases
• Checked teh mission critical back core, internet backing and support center 24/7 DB2 databases
• Monitored in-home centralized web based DBA tool for daily database backup status and other DBA related jobs log files, db2diag.log file, server & database, table space, etc.
• Implemented schedule and un-schedule database changes as part of Change Management Process
• Installed new databases, migrating and up-graded new fix levels as part of CIRATS complaints process
• Managed IBM process delivery as well as bank policies such as ID management, password management, health check, audit management and other bank data security management
• Handled database backups & restoration including full table-space, roll forwarded and other types of restorations
• Took care of Load/ Stress Tests in database to increase teh database perforce & solve connectivity issues
• Monitored teh database as a regular practice and involved in monitoring teh database daily database back-ups, table-space threshold utilizations, db2diag.log, health check deviations, database response time, file system utilizations & daily DBA jobs
• Improved teh database response time to identify teh heavy usage of CUP and Desk IO related SQLs, if any needed, identified and tuned teh database, database manager parameters & bufferpoos (or) advised/guided application teams for alternative/rewrite of SQLs statements to utilize teh existing resources
• Worked wif IBM Support team, AMS and clients during new and enhancement projects
• Refreshed teh full/part of database from Prod to Dev. environment
• Performed teh database DR drill activities as part of Disaster Recovery Process
• Resolved various database related issues i.e. database locking, slow reposing, OS & database level settings, DB2 installation and configuration parameters, high utilization of server resources, DB2 client & apps., connectivity issues and backup & recovery issues
• Provided 24/7 on call support to quickly resolve all databases related issues

Confidential

DB2 Database Administrator & DB2 Technical Support Specialist

Responsibilities:

• Worked on customer benchmarks for pre-sales opportunities for IBM along wif premium partners
• Involved in various new and enhancements projects wif IBM and IBM Partners clients in & around Singapore
• Delivered services to teh Asia's largest organization's mission critical databases in IBM Software Labs
• Worked closely wif teh IBM DB2 Labs and customer IT teams to co-ordinate and quickly resolve any DB2 related technical & PMR issues
• Provided on-site technical support & assistance under IBM Premium Support Program
• Installed & configured teh DB2 UDB v9.5 and v9.7 database s/w in AIX, SUN OS, SUSE Linux and Windows Environment
• Migrated various DB2 databases from DB2 v8.X, v9.1 and v9.5 to DB2 9.7
• Conducted official IBM DB2 UDB v9.5 and v9.7 classes for customers under IBM software training program
• Created & tuned portal and user databases for customer's production, DR, QA and development environments
• Managed regulator health & security checkups for teh mission critical databases and provided produce report to teh management on teh same
• Handled performance tuning of various database parameters and application problems
• Assisted in various database related issues i.e. database locking, slow reposing, OS level settings, DB2 installation and configuration problems, high utilization of server resources, DB2 client & apps., connection issues, backup & recovery issues
• Implemented teh HA techniques like db2 ACR facility, db2 wif HACMP and DB2 wif MSCS cluster for teh mission critical databases in Windows & AIX environment.

Confidential

Database Administrator

Responsibilities:

• Supported production, DR and development environments
• Interacted wif business users, application users and analyzed their requirements and emended teh best possible solution
• Installed, configured and migrated DB2 UDB ESE version 8.1, 8.2, and 9 wif latest fix packs on various operating systems like AIX, SUN OS, LINUX and Windows
• Set-up and supported mission critical databases using SUN-cluster wif db2 HADR
• Managed application & business users & enforced security policies in DB2 UDB modules and assigned responsibilities as required formatting error teh task
• Implemented change & release management controls, processes & practices to deliver quality services that increased client bottom line results
• Handled daily health check process of all databases and submitted daily reports to management
• Undertook various tuning efforts such as tuning database design, applications, memory structures, file I/O and contentions for database optimal performance using diagnostic tools such as DB2 Snapshots, DB2 UDB Event Monitor and Analyzer, db2pd, db2mtrk and DB2diaglog
• Prepared, tested & implemented back-up & recovery strategies for mission critical databases to ensure database availability
• Provided maintenance support for teh production databases and served as primary contact between teh application teams and IT support groups (DBA, Midrange, Problem Change Management, Application venders, etc).
• Resolved various applications database performance problems such as dead locks, SQL tuning, database tuning, concurrent connections and locking issues
• Reviewed and enforced standards, procedures and guidelines for developers and BU usage
• Involved in platform migration of critical DB2 databases from AIX to SUN OS

Confidential

Database Administrator

Responsibilities:

• Worked wif DDL, DML and DCL statements and taking care of creation of database & database triggers, alteration of table spaces, granting of privilege to users.
• Took care of database backup and recovery, export and import of data troubleshooting and fixpack installation.
• Used DB2 Utilities like Runstats, Reorgchk, Reorg, Load, Import and Export.
• Supported development team members to enhance query performance.
• Determined need for DB2 UDB utilities like reorg, statistics gathering, etc.
• Worked wif application development team for developing, modifying in testing applications.
• Enforced security policies in DB2 UDB Modules and assigned responsibilities as required.
• Monitored teh Database objects through Database Snapshot Monitors.
• Conducted On-line Backups, Offline Back-ups and Db2 Recovery Activities.
• Prepared DDL statements for database objects, moved database objects to and from DEV and QAT environment.
• Planned and implemented disaster recovery and conducted standard recovery testing using established documentation.
• Monitored, Administered tuning in production/ dev. of DB2 environments.