We provide IT Staff Augmentation Services!

Technical Database Manager Resume

2.00/5 (Submit Your Rating)

PA

SUMMARY

  • Over 15 years of experience as Sr Database Manager/Database Architect/Lead Oracle DBA in projects covering OLTP and Warehouse implementations, large and complex databases, Performance Tuning, Systems Integration, support and upgrades. Solid hands - on experience in implementations of Real Applications Clusters (RAC), High Availability Systems, Highly Scalable database systems, Backup and Recovery Strategy, Veritas Cluster, Grid Control Implementations and Support of Mission-Critical Systems.
  • Extensive experience with the right balance of management and technical skills to work effectively in a team and across cross functional groups. Proven strength in managing off shore resources, meeting goals and producing results through leadership, direction, guidance, continuity, excellent interpersonal, motivational and communicational skills.
  • Extensive experience in RAC Implementations, Database Migration, Database Upgrade, Oracle Installations and Patch Application.
  • Extensive Experience in design, implementing and performing Disaster Recovery.
  • Extensive Experience in design and implementing High Availability.
  • Provide work coordination, technical leadership and management for teams of DBAs, including project lead, project management, task assignment and coordination.
  • Experience in Agile Technology and ITIL technical solutions.
  • Participate in production on-call and escalation on-call rotation of 7x24 production environments.
  • Lead efforts to develop and improve procedures for automated proactive monitoring. Identify automation opportunities and implement solutions to improve efficiency, service reliability, productivity and cost of ownership.
  • Promoted consistency, standardization and efficiency within database environment.
  • Developed and implemented the strategic roadmap for the use of Oracle and Oracle products. Defined the set of products and versions to be used in production. Defined the standards, policies and procedures to be followed.
  • Developed and implemented policies, procedures, technical solutions and best practices that relate to the effective implementation and operation of VLDB, grid/RAC.
  • Very good understanding of broad range of technologies from systems, storage, networks, Middleware, ETL and other major application development tools.
  • Background in strategic planning, project management, staffing, training and employee relations.
  • A leader with strong ethics, extraordinary analytical skills and a demonstrated track record of achieving goals with dedication and dependability under tight constraints. Facilitate strong team organization.
  • Strengths in understanding and analyzing business processes and infrastructure requirements and translating them into technical specifications and capable of breaking down large projects to definable sub-projects.
  • Skillful in partnering, creating and managing business relationships with business clients from various divisions and geographies (local and international) while meeting business requirements and maintain strong, effective working relationships with coworkers.
  • Keen analytical focus with strong research, investigative and problem solving techniques for quick recognition of errors and anomalies. Excellent math aptitude and abstract conceptualization.
  • Managed multiple large scale projects and successfully delivered high profile/priority projects.
  • Coordinate and drive cross functional project teams, schedule, install, test and deliver contracted products within scheduled timeline and with a high degree of quality and customer satisfaction.
  • Lead/participate in meetings with customers and internal project resources.
  • Provide continuous feedback on project status and offer constructive options to ensure project continues to meet original expectations.
  • Identify resources and/or schedule conflicts and changing of project scope.
  • Communicate identification and resolution of business/project issues, as well as the monitoring, tracking and reporting on project deliverables to ensure adherence to project plan.
  • Assist project teams in data modeling and designing data accesses methods.
  • Contribute towards the inventory and metrics management processes to track IM assets.

TECHNICAL SKILLS

  • Oracle 12c,11g/10g/9i/8i/8x/7x, Oracle Exadata 11g, Teradata 7.0SqlServer 2000, MS Access, Hadoop
  • RHEL, Sun Solaris, Aix, HP-Unix, Windows 2000/NT/XP, MS-Dos
  • SQL, PL/SQL, C, Shell Scripting, Perl Scripting.
  • Oem grid control 12C,11.1,10.2.x, Oem data control, Sql Loader, Data pump, Exp, Imp, Toad, Sql Navigator, Queryman, DBartisan, Data
  • Junction, Erwin, Exceed, Kea, Informatica, Cognos power play
  • 7.0, Cognos Impromptu 7.0
  • Oracle AS Portal, Weblogic
  • Remedy, Peregrine, Clarify
  • Oracle RAC, Veritas Cluster, Microsoft Cluster, Oracle Failsafe
  • Oracle Streams, Golden Gate.
  • EMC Clone, RMAN, Netbackup, TSM, Sql Backtrack 5x/6x, Control MMaestro, Autosys, Automate, Cron
  • HP EVA 8100, MSA 2000, Sun StorEdge 3000/A5200, Sun
  • E10k/E6000/E5000/E3500/E450/E250/E420R/E220R, Sun
  • Ultrasparc 450, Aix 570,HP 9000
  • A180 /D200 /K460 /K570 /N4000 /k220,RP 7400, Compaq
  • Proliant DL series, Compaq ML series, Proliant 5000, 3000, 2000.

PROFESSIONAL EXPERIENCE

Confidential, PA

Technical Database Manager

Responsibilities:

  • Involved in vital planning for infrastructure setup.
  • Manage team of DBA’s (infra-structure) on site and off site spread across the globe. DBA categorized of Administration, Application, Operation, Production, Change Management, NOC, On-call support and performance optimization.
  • Implemented the ITIL standard model of RDBMS for the DBA teams: Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems.
  • Defined the Cost saving structured Shared-Service Model for the operational DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service requests.
  • Involved actively in technical solutions in bidding proposal for future Business development.
  • Managed enterprise-level Oracle 11g database systems, achieving the goal of 99.99% availability at acceptable level of performance.
  • Involved actively in technical solution of integrating ovd with ldap for Enterprise User Security.
  • Involved in strategic planning, project management, staffing, training and employee relations

Environment: Oracle 11.2.x/10.2.0.x, RAC 11g/10g, RMAN, Golden Gate, Oracle Grid Control, OID OVD, Linux Red hat 4x,5x,6x, EMC Clone, VPlex, Xbrick.

Confidential

Database Manager

Responsibilities:

  • Responsible for bringing latest technology in field of Database.
  • Manage team of DBA’s on site and off site.
  • Ensured team is compliant with regulatory standards and policies.
  • Responsible for evaluating Golden Gate technology leading to path of all live reporting.
  • Managing and providing technical leadership to DBA team.
  • Architect end to end migration of high profile external facing revenue earning database system from one Hardware to another with minimal downtime thus saving dollar amount.
  • Responsible for building DR environments using DataGuard.
  • Involved in Design of etl, Data warehouse, and BI studying of source system till end reporting.
  • Responsible for Building 2 and 4 Node 11gr2 external facing RAC environments.
  • Worked on bringing Hadoop in house and utilize for different applications.

Environment: Oracle 11.2.x/11.1.0.x/10.2.0.x, RAC 11g/10g, RMAN, Golden Gate, Oracle Grid Control, Shell Scripting, Hadoop, SQL server, Linux Red hat 4x/5x,6x, HP EVA

Confidential, DE

Lead Manager Oracle Consultant

Responsibilities:

  • Leading migration project of migrating Servers, database and application from one data center to other.
  • Lead the team for migration effort successfully completing migration well below project timeline.
  • Managed team functions viz. manpower planning, recruitment, performance appraisal.
  • Lead meetings with the Clients, Stack Holders and managing the expectations.

Environment: Oracle 11.2.x/10.2.0.x/9.2.0.x, RAC 11g/10g, RMAN, Shell Scripting, Linux Red hat 4x/5x, solaris, HP EVA

Confidential, PA

Sr Database Architect/Lead Oracle DBA Consultant

Responsibilities:

  • Responsible for designing strategy moving the production databases between the data centers from east coast to west coast saving multi million dollars in infrastructure, timeline.
  • Responsible for designing, developing and implementing the backup strategy enterprise wide using Data Domain Technology comprising of tapeless solution, replication to offsite for DR, encryption of data at rest and data in motion satisfying corporate security standards(sox,hipaa) thus saving multi million dollars.
  • Responsible for assessing the infrastructure requirements, provide the cost estimates using costing model and develop timelines for specified projects.
  • Worked with engineers, development teams, business product group and peers to understand the business requirements and help design develop and implement solutions that meet the business needs.
  • Responsible for evaluating Oracle Exadata Quarter Rack for bringing it In House.
  • Evaluated and brought in house Oracle Grid Control Monitoring thus saving dollar amounts.
  • Providing technical and project leadership for oracle database migration projects to newer Versions 10g/11g.
  • Responsible for preparing upgrade document for Oracle Grid Control Environment (oms, agent, database).
  • Responsible for maintaining standard across board, maintain uniform environments patchset and one off patches.
  • Provide status reports on key projects to senior management and make recommendations to optimize project implementations.
  • Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap.
  • Establish and communicate the security guidelines and participate in Security Risk Assessments.
  • Provide technical and management leadership to the consulting and junior staff.
  • Research and analyze all assigned anomalies to determine root cause - produce, review, track and log all findings and recommendations.
  • Collaborate with platform engineering and storage engineering teams to order the required hardware, install necessary patches and software to provide innovative solutions such as RAC and Grid computing.
  • Serve as team liaison to project managers for database administration and system administration services.
  • Responsible for road map of database versions, upgrades, PSU’s.
  • Oversees database administration support for production, development, and test environments to include day-to-day monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, SQL and database optimization and tuning as well as providing technical leadership and leading efforts to research, analyze, and recommend patches, upgrades, and new technologies surrounding all aspects of data management using relational databases.
  • Responsible for 4 installations of 12c, 11.1, 10.2.x Grid Control Environment.
  • Responsible for 9 rac installations of 11gr2 and 10gR2 2/3/4/6 node on Linux red hat, creating 15+ rac client production databases, upgrading rac environments (GI, clusterware, asm, database).
  • Responsible for staff planning, Conducting Interviews, Hiring, conducting performance reviews, goal settings, attracting and retaining the best talent.
  • Managed change control meetings ensuring that changes to production environments are validated and thoroughly tested.

Environment: Oracle Exadata, Oracle 11.2.x/11.1.0.x/10.2.0.x/9.2.0.x, RAC 11g/10g, RMAN, Oracle Grid Control, Shell Scripting, Linux Red hat 4x/5x, Sun Solaris 9, HP-UX 10.2/11, HP EVA, MSA

We'd love your feedback!