We provide IT Staff Augmentation Services!

Dba Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • Decisive leader and technical professional equipped with several years of progressive success. Background includes achievement in database management and administration, business continuity, disaster recovery and process improvement.
  • Client - focused professional with a proactive approach to all initiatives: Goal- and solutions-oriented adept at identifying opportunities to drive improvements.
  • Resourceful problem solver who demonstrates a unique combination of business and technical acumen: Exhibits strong leadership, analytical, relationship building, problem solving, and motivational abilities.
  • 18 years’ experience as a Confidential DB2/DBA. Worked on various database utilities to export, import, and db2audit logging, Adaptive compression, BLU technology and backup/restore databases. Working knowledge of UNIX.
  • AIX, Linux SUSE operating systems. Installed DB2 system on Linux environment. Experience in all phases of database products installation, implementation and maintenance

TECHNICAL SKILLS:

Skills: UDB Replication, 10.5 table adaptive compression, UDB database performance, Kornshell scripting, Database Federation, Net backup on VERITAS, Informatica installation, configuration, Regular database weekly drops etc.

PROFESSIONAL EXPERIENCE:

Confidential

DBA

Responsibilities:

  • Upgrading db2 databases form version to 10. 5
  • Turning on 10.5 feature adaptive server on table
  • Saving lot of space by turning on compression on indexes
  • Upgrading Informatica form 9.5.1 HF 3 to 9.6.1 HF4 and console configuration
  • Working on working nodes on separate server upgrade
  • Daily Informatica maintenance
  • Did HTTPS conversion on DEVL environment using our own certificates
  • Turning on HADR on certain databases.
  • Taking care of file system sizes
  • Production support
  • Worked with developers on grants
  • Database IPC QREP drops on weekly bases
  • Fail over the servers for the integrity
  • Taking care of Apache Tomcat patches via Hot fix upgrade
  • Installing UDB version 10.5 on servers and clients on AIX and cataloging the nodes and cataloging the databases.
  • Trouble shoot the database related problem in O&M and Prod environment
  • Taking care of a string (Multiple AIX servers and instances) of databases on daily bases
  • Migrating databases from one server to another on AIX
  • Daily morning checks of all the databases
  • Database storage capacity planning for database growth
  • Taking care of database federation from mainframe db to AIX servers, responsibility, change DBM cfg, creates federated server and create nicknames.
  • Working with VRTS people to install Net backup and Fail over on all the servers and cataloging the db’s via VIPS.
  • Setup performance monitor (database snapshots) and help the developers and
  • Working knowledge of setting up databases on Net Backups using VRTS.
  • Installing latest fix patches
  • Migrating the databases to other servers and configuring them.
  • Data warehouse Replication (apply capture scripts), Reading the logs find out Replication issues.
  • Taking care and Assigning DBA’s Remedy trouble tickets of last night production issues
  • PTR/CR (creating problem tracking report and implementation plans)
  • Worked on very large databases.
  • Doing 2 times a week IPC drops and DB drops.
  • Creating a project plan for the new projects.
  • Upgrading Informatica from 9.5.1 to 9.61. HF4
  • Configuration Informatica console
  • Configuring nodes and repository backup
  • DPF worked on Multi partition database in semi prod environment, we had a database spread across 12 partitions. Familiar with netbackup utility to take backup - backup and restore, db2 all statement, updating configuration parameters on all partitions, checking any issue with any particular partition, checking db2nodes file for any issue if database does not start on all partitions, adding space in the table space of multi partition database.

Confidential, Livingston, NJ

Database Specialist

Responsibilities:

  • Responsible for installation of DB2 UDB Server and Client software (v 6.1, 7.1 with the latest Fix Packs) on Unix (SUN/Solaris and AIX) and Windows plate forms with multiple versions of DB2 UDB concurrently available on the system.
  • Created and configured multiple UDB instances to provide independent environments for application’s development, testing, and QA for each version of UDB; installed DAS configured Client/Server communication for remote database administration.
  • Implemented and maintained the database security in development, testing, QA, and production environment.
  • Implemented shell scripts to ménage daily database backups in all supported environments.
  • Participated in evaluation of Dbvision and Servervision monitoring tools. Provided DBA support for the production environment, responsibilities include: UDB software installation, Create instance, Create database and related objects. worked with UNIX SA to create contingency servers for production databases. My responsibilities were to identify the file system, create the instances, and create the database and related objects on the contingency server.
  • Participated in several Business Continuation drills to restore host databases for mission critical applications. Created a disaster recovery plan for my servers:
  • Participated in conversion from Oracle to UDB RDBMS. My responsibility was to create instance, database, configure the database, estimate the space in, define nodes and create related objects.
  • Guided users through technical messages by producing a standardization of codes and developing an “English Type” manual. Action reduced user calls and facilitated timely responses.
  • Earned absolute confidence for the technical staff as internal clients found that regardless of the disaster our team was most able to return full operational status in minimum time
  • Understand the criticality of the databases, always willing to sit down with the technical team from start to finish. This involve contacting senior business people, contacting senior CTS individuals, explaining them the reason of the problem and what will take to fix it. Participated in several Business Continuation drills to restore host database for mission critical applications. Created a disaster recovery plan for my servers

Confidential

DBA

Responsibilities:

  • Provided maintenance and support for SQL server 6.0 on NT
  • Server. And Worked as a junior Oracle DBA. Primary
  • Responsibilities were to install SQL Server clients, maintain
  • Databases take backups and restore if needed.
  • Maintained a Small server with Confidential installed on it.

We'd love your feedback!