We provide IT Staff Augmentation Services!

Database Administrator Resume

Mclean, VA

CAREER SUMMARY:

  • Over 7 years of total IT industry experience working as Database Administrator & Database developer.
  • Experience in leading the DB2 development and production support teams.
  • Experience with installing Confidential DB2, Confidential Net Search Extender, Confidential Websphere Federation Server and Confidential DB2 Fix packs on UNIX and Windows system.
  • Experience in implementing HADR (high availability and disaster recovery) for backend database
  • Good knowledge of Confidential Datastage (Infosphere ETL tool).
  • Designed and developed Shell scripts and FTP (File Transfer Protocol) scripts.
  • Strong in optimization and performance improvement of complex SQL and XML queries.
  • Experience in regular DB maintenance activities, such as, backup, restore, indexing, reog, runstats etc.
  • Possess strong database and system administration skills.
  • Worked exclusively with DB2 PMR team and learned good insight into problem management processes.
  • Expertise in Analysis, Estimation, Design, Development, Testing, Supporting and Implementing application backend system.
  • Handling multiple projects and environments, excellent in multitasking.
  • SPOC for maintaining 12 Development, 15 SIT, 5 UAT, 3 Performance Environments & 2 CTE (Customer Testing Environment) database environments.
  • Thorough knowledge of issue troubleshooting and application maintenance.
  • Strong production support experience, handled level 2 application support.
  • Proficient in analyzing and translating business requirements to technical requirements and architecture.
  • Good communication skills, interpersonal skills, self - motivated, quick learner & team player.

SKILLS:

Databases: IBM DB2 version 9 and above

Programming: Procedural SQL (PLSQL), Unix shell Scripting Core Java concepts, XML, HTML

Operating Systems: UNIX, Solaris, AIX, Windows XP/7, zLinux

Tools: Rational Data Architect Developer, ER studio Data ArchitectDatastage (ETL tool), Rapid SQL Rational Performance Tester, Websphere Federation Server, Confidential Net Search Extender

Processes: Confidential On-Demand Process Asset Library (OPAL) Confidential QPACE - Quality Process Awareness and Competency Awareness, ASCA (Application Systems Control and Auditability), GenO.

Configuration & Change Management: Rational clear quest, Rational clear case, Manager Now.

PERSONAL STRENGTHS:

  • Hard working, fast learner and enthusiastic learner.
  • Systematic and ready to accept challenges.
  • Team player, believe in walking hand in hand with the team.
  • Acquired sound Technical Knowledge through Hands-on experience
  • Punctual - Respect for people and their time

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential, McLean, VA

Environment: Linux, Solaris, Confidential DB2, Oracle Weblogic Application Server, Webmethods, AIX

Responsibilities:

  • Work as single point of contact Database administrator/developer for all non-production backend environments i.e., 12 Development, 15 SIT (System Integration Testing environments), 5 UAT (User Acceptance Testing) Environments, 3 Performance Environments & 2 CTE (Customer Testing Environment); plus 30 environments currently being build.
  • Responsible for deploying new changes into databases (both structure and data related). Also responsible for maintaining databases at production baseline.
  • Handle performance related issues. Analyze & work towards solving query, system & application performance problems.
  • Backup & restore databases, schemas & tables.
  • Worked on improving performance of XML queries.
  • Responsible for providing, maintaining and monitoring adequate privileges on databases & data.
  • Worked on designing solution for a major ADS application change project. Designed process to create version ids through db2 utility, in addition to designing export, import scripts. This made front end developer’s task simpler.
  • Our team is working on development a centralized Tracking tool for different aspects related to work handled by the team - Issues (both environment & application), Environment allocation requests, Deployment requests, Enum Generation etc. I worked on designing the backend data model for this project based on the requirements gathered in discussion with the developers. Also implemented the same in db2 backend system.
  • On and off I help development teams design and develop database solutions for their project requirements.
  • Proactively took responsibility of two entirely new processes which were brought into the team - a) Enum generation process involving MS access macros and Db2 database, 2) Code generation involving maintenance, updating and versioning of all application attributes. Took responsibility of designing the versioning & maintenance process for both activities.
  • Responsible for solving application issues/bugs related data or database. Ability to easily check front end logs - Oracle Weblogic and debug the issue.
  • Have also worked hands-on on solving application issues related Weblogic configuration, Webservice calls, Null pointer exceptions, Java heap size, connectivity over firewall etc.
  • Maintain & deliver documents highlighting changes, level and usage of databases on all environments for easy access and decision making by project teams.

Database Administrator

Confidential

Environment: AIX, DB2, Cognos, Websphere Application Server 6.1IBM Infosphere DataStage 8.1

Responsibilities:

  • Have been associated with the project since the very beginning and start of the application implementation.
  • Responsible for setting up application backend system from scratch.
  • Installed Confidential DB2, Confidential Net Search Extender, Confidential Websphere Federation Server and Confidential DB2 Fix packs on AIX and Windows system.
  • Responsible for designing and implementing application database objects using Confidential DB2 and Data modeling tool.
  • Responsible for backup, restore and maintenance of application/session databases using Confidential DB2 and associated tools on AIX, Linux and Windows environment.
  • Develop application data model using Confidential Rational Data Architect.
  • Worked on implementing HADR solution.
  • Maintain database scripts and DDLs (Data Definition Language) using Confidential Clear Case repository tool.
  • Responsible for analyzing, reviewing and designing requirements from backend perspective.
  • Create or optimize complex SQL queries for ETL (Extract Transform and Load) - Confidential Datastage.
  • Worked on migrating application from Confidential Research environment to Confidential Dev & Production Servers.
  • Prepared and delivered data migration plan for same using Confidential OPAL (On demand Process Asset Library).
  • Design and develop Confidential AIX shell scripts and FTP (File Transfer Protocol) scripts.
  • Prepared Preliminary and Detailed Design Document for various business requirements.
  • Co-ordinate with external Datasource application teams which feeds data into iBAT, understand, analyze and implemented various enhancements and changes for the same.
  • Move to Production Planning (MTP) which includes creating a deployment plan and instruction documents.
  • Coordinate with deployment team for application fixes to be deployed on production servers.
  • Work individually on minor enhancement and changes and deliver the same to customer.
  • Worked with application performance testing team. Documented various scenarios and load to perform stress testing using Confidential Rational Performance tester.
  • Work on solving performance related issues, determine the root cause and applied fix the same.
  • Analyzed and worked on implementing database archival method to address performance issues.
  • Work on PMR (Problem Management Report) tickets with the Confidential Software group for various technical and performance issues in the application to learn insights of performance improvement techniques.
  • Perform preliminary analysis and provide appropriate solutions for Problems/Issues; queue it to Level 3 for further analysis and implementation.
  • Also involved in L3 to identify solution to problems identified.
  • Worked on the BCP (Business Continuity Plan) for application from database perspective. Prepared and executed plan to enable business continuity in case of a disaster in current application environment.

Confidential

Segmentation Modeling Tool Developer

Responsibilities:

  • Successfully completed 5 months internship at Confidential as Segmentation modelling tool developer.
  • Successfully completed 3 months internship at Confidential .

Hire Now