SUMMARY

• Over 14 years of IT experience with emphasis on Database Administration, development, migration, Business Requirements Analysis, Application design, testing, implementation and maintenance of databases on DB2 UDB EE, DB2 UDB EEE and DB2 UDB AESE, ESE with DPF on LINUX, UNIX Windows Platforms and Mainframes.
• 10+ years of rich experience in Database Administration using DB2 UDB and 3+ years of experience in PostgreSql with strong business knowledge of Financial, Insurance and Manufacturing projects
• Worked through all phases of system development life cycle and has performed as a senior DB2 UDB DBA
• Expertise in development support activities including installation, configuration and successful deployment of changes across all environments
• Migrating DB2 UDB databases and applying fix packs to keep DB2 at most recent level
• Performed migrations from db2 on AIX to db2 on windows
• Provided production support for critical applications running on 24/7 basis
• Experience in implementing Backup and Recovery strategies, SQL Replication, Q Replication and developing Architecture for building a database by using tools like Erwin/ER studio and writing necessary Shell scripts
• Running utilities like LOAD, IMPORT, INGEST, EXPORT, REORG, RUNSTATS, REBIND in db2 luw and VACUUM, ANALYZE, REINDEX, COPY and EXPLAIN in PostgreSql.
• Installed PostgreSql database servers and performed upgradations
• Created new databases on PostgreSql, Performed Backups and Restore.
• Worked with third party tools like Fog light, TSM, BMC Patrol, VERITAS Net backup, Remedy, and Toad.
• Database maintenance, backup, recovery, performance monitoring, tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning
• Extensive DB2 DBA and DB2 Connect experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of database applications.
• Experienced in setting up backup policies and retention policies using Tivoli Storage Manager and Veritas net backup and do the alignment from db2 databases, Test and schedule and report any failures and apply upgrades and maintain raise PMR with Confidential for any unknown issues.
• Wrote Several Complex Stored Procedures, Functions and worked on performance tuning and wrote perl, korn shell, Jmeter scripts for stress test.
• Familiarity and experience with data warehousing and DB2 Pure scale, Data center Replication Symmetric Replication Data Facility (SRDF).
• Excellent analytical and functional skills with strong communication and interpersonal skills. Actively involved in the full project life cycle, user requirements to implementation. Willing to learn and adapt to new challenges.
• We discovered that DB2 Health Monitor in v9.7 was causing heavy locking and slow connection times in our heavy transaction volume application. Every two hours, when DB2HMON would fire, it would drag the entire system down. We solved the problem by deactivating Health Monitor.

TECHNICAL SKILLS

Operating System & Platform: AIX 5.2/4.3.x,7.x, Solaris 2.6/2.7/8, RH Linux Advanced Server 2.1, 3.0,6.6, Windows 2000/ NT 4.0, Windows 95

Databases: DB2 UDB V.7.X, 8.1, 8.2, 9.1, 9.7, 10.5(ESE) Single and DPF, V.7.2 (EEE), SQL Server, Oracle,PostgreSql, mongodb, Hadoop on Hbase and netezza appliance, MYSQL.

Data Modeling Tools: ERWin V4, ER studio

Modeling Methodology: ER & Dimensional Modeling

Data Access Technologies: ActiveX Data Objects, OLTP, ODBC, JDBC

Programming and Scripting Languages: Shell Scripting, AWK, SED, SQL, Visual Basic, C, C++, Java, JSP, ASP, JAVA Script, Python

Web Servers: WebSphere 5.x,8.x,Apache Tomcat 5.9, Apache HTTP server

Applications: MS Office

Advance Technologies: SOAP/XML Web Services, Net Search Extender, Hadoop, DB2 Replication, HADR,AWS

Tools: / Utilities: Fog light, Toad, Guardium, Jmeter, Quest Tools, BMC Tools, Erwin, Power Designer, Tivoli Storage Manager, and Veritas Net Backup.

PROFESSIONAL EXPERIENCE

Confidential

Senior DB2 UDB DBA/Programmer

Responsibilities:

• Migrated db2 instances from v8.1 FP 11 to V10.5 FP5, V11.1 FP5 and completed production environments with respective DR’s.
• Upgraded PostgreSql from v8.x to v9.x, V10.x.
• Designed, Planned and created new databases, tablespaces, tables and associated objects on PostgreSql databases.
• As part of Migration from DB2 on LUW to Postgresql, Converted DDL’s manually to postgresql syntax and Created tables and Stored procedures and associated triggers as part of Proof of concept.
• Performed configuration tuning and query tuning on postgresql.
• Holds conceptual knowledge of High availability in postgresql.
• Recently encrypted databases using DB2 Native Encryption
• Implemented High Availability and Disaster Recovery (HADR) supporting load activity.
• Improved performance of Backups and Restores in db2 luw, mysql and PostgreSql.
• Wrote a batch script to connect to several databases and pull out results.
• Enhanced security by encrypting data at rest and automated key rotation.
• Used in house DR strategy to perform an incremental restore along with log copy strategy.
• Created several new complex procedures and enhanced existing procedures to meet business requirements.
• Supporting sprint releases uses waterfall strategy on weekly basis and documenting changes over JIRA a ticketing tool.
• Provided bi - directional replication solution using federation and triggers and procedures.
• Provided and implemented a solution for a requirement to add unlimited columns with sum of column length greater than 32k page size.
• Supported application upgrades on all databases with dual fallback strategy in DR environment, resolved ad hoc issues faced by application team related to data integrity during upgrade.
• Building and supporting production, DR, UAT, XAT and development and DPF environments.
• Supported application performance testing by monitoring database using shell, Perl script and captured db2top at regular intervals and replay when needed and providing report.
• Involved in capacity planning and space management. Worked on space estimate and table space design to accommodate large amount of data in data warehouse environment with DPF.
• Creating new database objects and promoting them with releases.
• Automated adding a partition key on a table and schedule in cron.
• Coordinating with developers to install new software releases.
• Support Data Architects to reverse-engineer and help document the application, which came with minimal instructions.
• Database monitoring using Snapshots, occasionally, statement/connection/transaction Event Monitor and Access plan analysis via EXPLAIN/EXFORMAT.
• Troubleshooter I/O issues and projected to Capacity Management team.
• Scheduled MySQL backup job in crontab

Confidential

Senior DBA

Responsibilities:

• Worked on installation of different versions of DB2 UDB ESE with DPF on AIX 5.
• Worked on installation and fix pack up gradation on windows 2000 server
• Created new databases and performed migration from db2 v9.7 on AIX to db2 v9.7 windows
• Performed performance tuning on windows and scheduled jobs on task manager
• Wrote bat scripts for monitoring and power shell on windows.
• Involved in setting up DB2 UDB database on SAP application and having hands on as a DBA on DB2 UDB with SAP
• Involved in setting up HADR and wrote scripts for day to day monitoring.
• Apply fix packs, monitor Confidential maintenance releases and communicate them to business.
• Developed scripts to capture benchmarks for performance of database. Captured and maintained capacity planning reports including CPU, MEMORY, I/O, Disk Space, and Projected utilization based on future business requirements.
• Developed database security strategy to provide access to large number of users in production environment.
• Generated and implemented DDL for several projects from the logical model using Erwin Data modeling.
• Involved in capacity planning and space management. Worked on space estimate and tablespace design to accommodate large amount of data in data warehouse environment.
• Involved in ETL design, architecture, and performance tuning including load strategies.
• Created, maintained, and monitored onsite archive, recovery and data retention strategy for all databases servers. Create, maintain, and monitor backup jobs; Ensure backup jobs are able to support of documented SLAs. Maintain archival strategy, logging strategy for point in time recovery.
• Created backup and there retention polices for database on TIVOLI STORAGE MANAGER and report any failures to team and do a root cause analysis and find a resolution and apply a fix, For unknown issues will raise a PMR and fallow up and apply recommended changes.
• Coordinating with the development team for coding static SQL stored procedures. Also coordinated with application team for SQL Optimization, SQL Analysis and Streamlining. Has experience working and analyzing with SQL Visual Explains output.
• Maintain documentation of database infrastructure and software assets.
• Attended training on DB2 Pure Scale provided by Confidential to HSBC.
• AIX / LINUX / WINDOWS Development/Production Support.
• Work with on/offshore teams (appl. and DBA teams).
• Helping other GLT teams to achieve organizational goals.
• Provide consultancy on Midrange DB2.
• Timely and accurate communication with all stakeholders.
• Proactive defect tracking.
• Task Automation using perl, korn shell, awk and sed.
• Adhere to standard processes and suggest improvements.
• Ensure successful ITIL audit.
• DB2 Midrange ever greening.
• Provided 24X7 on call support for production servers.

Confidential

SOA Developer

Responsibilities:

• As Part of Confidential, worked on multiple projects (Insurance, Banking and Retail Sectors)
• Responsible for the creation of Technical specification documents and user stories
• Having good experience in developing Web services in IIB and Message Broker (REST & SOAP Based)
• Expert in design and development using Confidential WebSphere tools like Message Broker and MQ
• Extensive experience with build and deploy BAR files in various environments
• Hands on experience with HTTP/FTP/NFS Front side Handlers to receive information from various sources
• Strong programming Knowledge of Esql, Xslt
• Worked with File and Collector nodes to process the Batch updates
• Responsible for the ESB Layer design involving IIB/Message Broker, MQ Series, WTX and DataPower
• Developed Message flows to transform messages from XML - Copybook, EDI - XML and XML -JSON
• Designed and Developed Error handling procedures
• Designed and developed Web services using SOAP and HTTP Nodes in Synchronous and Asynchronous modes
• Implemented WS-Security, Inter-operability and SOA Governance in DataPower
• Implemented Load balancing and Service versioning
• Implemented XML Firewall, Web services Proxy and Multi-Protocol Gateway services in DataPower
• Developed logging frameworks in IIB/Message Broker and DataPower
• Configured Front-End (HTTP, FTP, MQ) & Back End handler Configurations, Processing rules, Matching rules, All Processing actions, XML manager in DataPower
• Created AAA Services with LDAP for user authentication, SSL profiles for transport level security and configured Service Level Monitors to collect service usage metrics
• Developed IIB services to do routing, filtering and transformation
• Developed Restful web services in XML and JSON format
• Developed type trees to model messages and implemented complex mapping solutions in WTX
• Developed services to Interact with DB2 and Oracle Databases via SQL and Stored Procedures
• Designed and developed message flows to interact with SAP (Inbound and Out Bound)
• Integration with WSRR from Message Broker and DataPower
• Production support team maintaining IIB/Message Broker and MQ Series
• Configuring remote connectivity to access remote queue managers and brokers using set mqaut commands
• Involved in the creation of various MQ objects like queue managers, queues, topics, subscriptions, channels and listeners
• Enabled triggering, configured work load balancing and implemented publish and subscribe
• Created configurable services by executing MQSI commands as scripts on Linux machines for the creation of JDBC, SMTP and Record and Replay Database settings
• Created Automated build and deploy ANT tasks with specific targets using MQSICREATEBAR, MQSIPACKAGEBAR, MQSIAPPLYBAROVERRIDE configured with accordance to the commits made by the source control system
• Designed and Developed Message flows to Handle Large files
• Designed and Developed Scheduling and retry flows using timer nodes
• Implemented Synchronous/Asynchronous Collection and Aggregation message flows
• Developed Java Functions and also done development in JCN in Message Broker
• Message transformations using XSLT, XQuery and DataPower extension functions to support JSON/XML formats