Dba Technical Lead Resume
NY
SUMMARY:
- Database Administrator Lead, having almost 23 years of IT experience within Media/Entertainment, Telecommunication, Financial and Transport Industries. Expertise in driving the development and operations of high - profile, mission-critical database systems to optimize the use of existing infrastructure, maximize productivity with full technological potential.
- Management Philosophy is to build Effective Teams with Thorough Planning, Articulating Risk and Managing Globally diversified teams.
- Understand the Challenges of 24*7 Production Environment, combined with Outstanding Leadership ability, Creative Problem Solving and Trouble Shooting skills in both Strategic and Tactical areas. Excellent Communication, Presentation, and Management Skills.
TECHNICAL SKILLS:
Operating System: AIX, HP-UX, Solaris, Linux, Win NT, Windows Server, Windows XP
Audit Tools: Guardium 6.x, Lumigent 6.x
Databases: Oracle 7.x/8/8i/9i/10g/11g,12c, MS-Sql Server 2000, Sybase, MS-Access, DB2.
Languages: SQL, PL/SQL, Clipper, COBOL.
Replication: / DR Oracle 9i / 10g Data Guard, Quest SharePlex 4.7, Oracle Streams, Golden Gate.
TOOLS: TSM, ASM, OEM, VERITAS Netbackup, ServiceGuard, TOAD, TKPROF, SQL*Trace, Quest Foglight, Quest Spotlight, Quest Performance Analysis, AutoSys, Swingbench, VERITAS Cluster, DBArtisan, Embarcadero Rapid Sql.
Version: Control VSS, PVCS, Clear Case, Source Depot, Share Point.
Change: Control ChaRm - Peregrine Service Center, Magic, QuArc, HEAT.
Other Software: Erwin, Visio, Quest LiveReorg, Win Test Techn, Octopus and Test Arch, TIDAL.Business Domain Software Consulting, Finance, Telecommunication, Transportation,Banking, Insurance, Manufacturing, Utilities, Airline and Engineering.
PROFESSIONAL EXPERIENCE:
Confidential, NY
DBA Technical Lead
Managerial Responsibilities:
- Technical Lead for HBO. Recruited and setup new team, manage day to day Production Support tasks.
- Having a team at onshore and three other locations geographically to support 24x7, couple in Philippians and India.
- Extensively trained offshore team to support all business requirements, corporate standard processes from onsite.
- Responsible for the strategic plans, resource allocation, day-to-day operations of the database management group.
- Administering and monitoring the team’s work load throughout ongoing projects, setting priorities and goals for the team, conflict resolution, mentoring and setting up Production Control Change Management standards and processes.
- Lead several Oracle 10g to 11g database upgrade projects, involving platform moves from Sun/Aix to Linux.
- Lead database security liaison for Database tea for Sarbanes-Oxley audit monthly reviews. Handle audit controls.
- Provide metrics to upper management on current database environments. This is to support and justify annual budgets. Metrics include database inventory and availability, projects, CPU coverage, capacity planning, and Heat ticketing.
- Accountable for Database Audit reports for SOX compliance and policy remediation for dba team for corporate.
- Streamlined Patching and Upgrade processes within DBA team as well with Engineering/Unix teams for OS patching.
- Implemented Dataguard as a HA solution for all HBO production systems with Max Availability/Performance mode.
- Driving POC’s within team for 12c upgrades, Rman enhancements, Capacity Planning, and HA solutions.
- Architect for Upgrading Oracle Enterprise manager 11g to 12c Cloud Control. Setup Templates, Notifications.
- Created Business Level Groups & Templates and associated Environments accordingly for effective Monitoring.
- Set up Monitoring through Grid Control for heterogeneous databases, Tidal Scheduler, Nimsoft and Unix utilities.
- Coordinated the efforts for corporate wide Live Active DR End to End Testing, twice in a year.
- Coordinated Migration efforts of OID, involving Load Balancer (F5), Active / Active DBs from Aix to Linux.
- Coordinated Migration of IAS, involving Applications (DDT&PPR) from Aix to Linux.
- Implemented Rman active cloning from production to lower environments and standby setup in DG environments.
- Coordinated for complete End to End Oracle 12c Upgrade efforts for all our support Databases.
- Trouble shoot data contingency issues with TSPITR, Flashback, and guaranteed restore/save points as applicable.
- Space Management and Monitoring Automation for heavy OLTP terabyte sized databases and for FRA locations.
- Setup multiple Dg environments in production and handed off the detailed documented process to offshore.
- Thorough planning during upgrades, Quarterly patching & Unix maint., targeting minimal downtown for db/apps.
- Proven Ability in resolving severity one issues meeting SLA’s within expected timeframes meeting critical deadlines.
- Created and implemented shift turn over and rotation process for every offshore team globally.
- Designed and tuned secure access rights for all the users to permit legitimate users access to only those resources they are authorized to use meeting Sarbanes Oxley’s compliances. Implemented pbrun for OS level access to oracle acct.
- Provide support by coordinating with off-shore resource and implemented shift turn over process and maintain SLA.
- Streamlined processes for documentation of Incident reports, with detailed analysis on root cause and solutions.
Platform: Oracle 10g, 11g, 12c, AIX, Linux, Sun Solaris, TOAD, HEAT, TIDAL, NetBackup.
ConfidentialDBA Technical Mgr
Responsibilities and highlights:
- Implemented and Maintained RAC databases on Oracle 8i, 9i, 10g, 10g ranging from 500 GB to 2 TB.
- Rolled out plans for upgrading 8i/9i databases to 10g and for database migrations from AIX/Sun to Linux.
- Responsible for 100% uptime of mission-critical databases. Configured foglight for alerts and notifications.
- Handled core team at onshore and support team in India in couple of cities. (Chennai & Bangalore).
- Revised/Implemented standards as member of Change/Release Mgmt team for accurate data governance.
- Setup Policies and Standards for Sarbox Audit Compliance. Streamlined, automated several audit processes.
- Installed Oracle, Setup & Configured Highly Complex databases with Security Controls as needed.
- Responsible for Production systems Performance, Storage Capacity, Space Mgmt trending and analysis.
- Laid out detailed and thorough deployment plans with various milestones and checkpoints for EPIC database upgrade from oracle 8.x to 9.2 coordinating tasks with Unix, Engineering and Network teams.
- Work delegation to offshore monitoring Confidential Databases day-to-day activities and code promotions.
- Documented and Maintained Catalog for all environments with maintenance, backup contingency, rollback plans for all major, critical deployments across board.
- Engineered cost-effective solutions, with emphasis on Audit controls, Change-Release-Project Management.
- Installed, Configured and Setup Lumigent Audit tool and underwent training on Guardian Db Auditing tools.
- Streamlined standards for Regression, System, Integration, and Performance-Load tests during upgrades.
- Technical Lead liaison between On-site / Off-shore teams with seamless support to clients 24/7.
- Thorough Planning with minimal downtime for major Upgrades, Patching and Storage moves coordinating with Engineering, Unix-Windows and Database Teams.
Platform: Oracle 8i, 9i, 10g, 10g RAC, 11g, Linux, Sun Solaris, HP-UX, SQL Server, Sybase, TOAD, VERITAS Netbackup, OEM, Streams, Golden Gate, Oracle 11i BCV, VERITAS Cluster, DBArtisan, Spotlight, Foglight, Rapid SQL, Lumigent 6.x.
Confidential, MASenior DBA Lead
Responsibilities and highlights:
- Lead the datacenter migration efforts for Teradyne, Boston, MA.
- Responsible for Co-ordination and Delegation of Work for Datacenter Migration between Onsite/Offshore.
- Team was spread across onsite and offshore with couple of destinations. (Chennai & Pune)
- Capacity Planning for terabyte sized servers and databases corporate wide and Infrastructure setup.
- Installed, upgraded and patched database environments from 9i to 10g on Linux environments.
- Responsible for logical and physical data-modelling, working with Stake holders and Application teams.
- Streamlined and Automated for Dev/Beta/QA/Staging from production environments.
- Setup Corporate wide backup, recovery strategies including complete recovery, tablespace recovery, data file recovery, incomplete recovery and imports handling different type of failures.
- Performance Tuned Terabyte sized applications implementing partitioning, Indexing, Archival strategies.
- Implemented Version-control utility (PVCS) for Code promotion and rollback across environments.
- Reviewed Code-promotion standards adhering to change management policies.
- Implemented SQL profiling and outlines for major performance impacting application code implementing history tables, partition pruning, hints, and histograms for index skewing.
- Technical liaison between onsite/offshore for outstanding issues, root cause analysis and Incident Mgmt.
Platform: Oracle 10g, Linux, Sun, Quest Performance Analysis, Veritas NetBackup, DB Artisan, Toad.
Confidential, OHDba Manager
Responsibilities and highlights:
- Installed, configured and provided 24*7 supports (in house and remote) to mission critical instances.
- Provided level III support resolving all escalated problems from Jr DBA's (Level II Support).
- Lead a team of 25 Dba’s across global locations providing high availability of critical systems.
- Performed database modeling using Oracle Designer for the prototype information system.
- Coordinated efforts for application patches with complex application cross dependencies.
- Responsible for security control reviews with appropriate user privileges and roles, profiles, password verification functions, allocation of resource limits and tablespace quota for users.
- Performance tuned critical application code.
- Implemented procedures for replication using distributed database technologies.
- Installed OEM, configured database and host level templates for database monitoring, alerting, notifications.
- Assist the development team in application upgrade, implementation and resolution of technical issues. This includes design review, code review and implementation of any new or modified data structures.
Platform: Oracle 8i, 9i, (8.1.7.4 / 9.2.0.5 ) Sun, Quest Central, OEM, Toad, Erwin Data Modeler.
ConfidentialSenior DBA Lead
Responsibilities and highlights:
- Upgraded 2 TB Oracle database from 7.1 to 8i. Patched the databases in different versions.
- Coordinated OS patching with application and database teams.
- Responsible for logical and physical database design and 24*7 availability of production systems.
- Allocating system storage and planning storage requirement for the databases.
- Periodic Export/Import of the databases and Database refreshes in multiple phases.
- Creating/Altering/Modifying tablespaces, users, procedures, packages, triggers as and when required.
- Creating Oracle users, setup audit controls as required.
- Oracle enterprise Manager tool usage for backups of different kinds.
- Tuned sql/plsql scripts. Used Sqlldr for moving data from access/other legacy systems into oracle.
- Prepared budget for Infrastructure setup, licensing and maintenance of oracle databases.
- Diagnosed database corruption problems, wait event analysis and implemented solutions.
- Introduced architectural solutions to eliminate bottlenecks and improve performance.
- Responsible for specifications review, application design for rewrite of critical projects.
- Performed recovery / refreshes of development and QA environments as and when needed.
Platform: Oracle 7.1, 8i, Windows NT, Quest, OEM.
ConfidentialDBA Team Lead
Responsibilities and highlights:
- Converted DB2/UDB legacy systems to Oracle 7.3 databases for British Telecom, Nexus Systems.
- Provide 24x7 supports for major application databases and handled numerous complex code promotions.
- Re-designed database layout implementation of OFA and raids 0+1 and 5.
- Re-architected the schema objects and created indexed based on stats pack report findings/recommendations.
- Tested load cycle for existing systems with PL/SQL debugger. Created new load cycles from Access databases into Oracle tables.
- Restored control files, cloned databases, renamed databases with trace control file backup.
- Work with Production Support Groups, Application Dba’s, and Stake Holders on Analyzing business requirements &responsible for Code Promotion &Validations enabling smooth beta & prod deployments.
- Maintained data dictionary definitions for various entities and attributes of new data models in Oracle.
Platform: Oracle 7.3, Unix, Windows, Toad, Erwin.
ConfidentialDBA
Responsibilities and highlights:
- Migrated DB2/UDB 500GB to Oracle.
- Created conversion scripts, use case for verification for all database objects.
- Created mapping document to validate architectural changes between DB2 and Oracle Database.
- Responsible for implementing new Infrastructure and setup Oracle 7.3 for all application data.
- Monitoring and optimizing the performance of database in UAT.
- Collecting system statistics from oracle dynamic performance views.
- Perform periodic Export/Import of the databases for UAT refresh.
- Extensively supported development, testing & production teams on every phase of release.
Platform: Oracle 7.3, DB2/UDB, Windows, Erwin.
ConfidentialJr. DBA
Responsibilities and highlights:
- Responsible for all Database Object Changes during code promotion from UAT to Production.
- Monitor database health and constantly tune up for improve performance in Production.
- Monitor, optimizing performance of database using SQL tuning, tkprof, sqltrace, explain plan.
- Daily monitor database space management and non-production environment refreshes.
- Assist the development team in application upgrade, code promotion and resolution of technical issues.
- Daily Monitor Jobs, backups, logs and overall server's health.
- Apply patches and TAR bug fix to the database.
- Scheduled and monitor backups on all environments.
Platform: Oracle 7.1, Developer 2000, Windows.