POSTGRESQL RESUME EXAMPLES
Resume Builder
Edit this resume to make it your own!

Your Name

Senior DB Principal Consultant/Technical Lead/Manager

New York, NY

your.email@example.com
111-222-3333
www.your-website.com

Summary

  • Over 13 years of experience in information systems, including defining the roadmaps, budget, staff, infrastructure and facilities, and overseeing the implementation of plans for increasing growth, and ensuring high performance/availability for maximizing business continuity for organizations with local and global presence.
  • Highly experienced in leading and managing diverse multi-cultural teams of 25+ people in stressful 24/7 environments, prioritizing deliverables, and optimizing resource utilization across projects to accomplish targeted goals and assure that Service Level Agreements (SLA) are fulfilled.
  • Highly experienced with hands on DBA/Architect in capacity planning, implementation and management of critical mixed environments configured with active-active, active-standby options implementing Oracle's DataGuard, 9i/10g/11g Real Application Cluster (RAC), Automatic Storage Manager (ASM), GoldenGate, Exadata v2, and PostgreSQL 9.1
  • Highly experienced in Application assessment, capacity planning, performance tuning/enhancement, response time improvement and identification/analysis of bottlenecks at different levels of infrastructure (front-end, middleware, back-end, network, bandwidth connectivity, storage growth, CPU, Memory, and maintenance of datacenters).
  • Highly experienced in designing architecture, planning and deploying RAC with Transparent Application Failover (TAF) environments along with Cache Fusion and Flashback technologies for high availability and zero downtime.
  • Experienced in modeling and designing online transaction processing (OLTP), data decision support (DDS), warehouses (DW) database systems, and extract/transform/load (ETL) processes. Along with creating, and maintaining Database Objects, including application and user schemas/roles/privileges, partitions, packages, stored procedures, functions, triggers, database links, snapshots, tables, constraints, clusters, views, indices, sequences, and synonyms.
  • Highly experienced in software development life cycle (SDLC) methodologies and procedures.
  • Experienced in integration of external financial data systems such Broadridge, MarkIT, Reuters, and Bloomberg.
  • Experienced in designing appropriate database models, constructs and feeds for multiple processes such as real-time pricing information, holdings, trade details, performance data, and other market data.
  • Experienced in maintaining vendor and client relationships and attracting/retaining talent.
  • Experienced on Script Programming using korn and bash shell, Perl, Awk, ps, sed, grep, and archiving tools like tar, gunzip, gzip, backup, auditing both external auditing and internal auditing, experience on various UNIX and Linux platforms like Redhat, SuSe, AIX, and Solaris

Work Experience

Senior DB Principal Consultant/Technical Lead/Manager

Bank of America Merrill Lynch, New York, NY

Dec 2006Current

Global Wealth and Investment Management (GWIM)

As Senior Principal Technical Lead/DBA, I actively participated in DB/middleware/application tuning, performance capacity assessments and implementation of recommended enhancements for BoA's Online Brokerage, a web-based transactional system generating over $100 million in annual revenues. As a result of our improvements, BoA's application moved from 300th position to the top 25 for response time and top 10 for availability on industry benchmark charts, and the global cash deposit rate increased by 80%.
  • Managed and led geographically and culturally diverse team (7 database administrators, 9 developers and several other support engineers based in London, Bangalore, Romania, Istanbul)
  • Coordinated efforts between in-house and outsourced teams, data center managers (New Jersey, Chicago, Santa Clara) and major vendors (Oracle, Sun, several other hosting providers such as Savvis, SunGuard)
  • Tracked projects with MS Project and provided status reporting to management; implemented process and policy changes to enforce proper application change control.
  • Led regular global team and stakeholder meetings to discuss and prioritize necessary enhancements to database environment and resolve issues such as security and proper use of database accounts and data by implementing separation of duties.
  • Trained team members on available vendor support resources and conducted knowledge sharing sessions as well
  • Responsible for the development, deployment and ongoing operational management of the database environment (applications and hardware infrastructure) underlying BoA's online brokerage website.
  • Led the conversion and integration of online brokerage systems with the two largest clearing platforms in the industry (Merrill Lynch and NFS).
  • Supported bank accounts conversion and merger for BoA and Merrill Lynch.
  • Designed and implemented 9i to 10gR2 and 11gR2 migration for all corporate databases for both RAC and non-RAC environments.
  • Designed and implemented the migration of several database applications cross platform from Sun 10 to Linux using GoldenGate
  • Led Exadata v2 project planning, implementation, migration, and tuning of several databases and application along with GoldenGate production, disaster recover (DR), and quality assurance (QA) - to be used for mission critical applications.
  • Led RAC project of 2 nodes, 3 databases with ASM and DataGuard; Oracle 10gR 2, on Solaris 10; responsible for all major dbs synchronizations across the globe implementations using GoldenGate technologies, Veridata, and Director.
  • Led the migration of several application/databases off oracle to PostgreSQL 9.1, single instances and replicated environments
  • Coordinated with SAs to ensure that most up-to-date Oracles CPUs were installed on all database systems and necessary O.S patch updates were successfully tested and deployed.
  • Designed and modeled several DSS/reporting systems for Data warehouses to off-load and improve performance on the transactional relational database management systems (RDBMS).
  • Integrated market data from external providers (Morningstar, Lipper, Reuters, S&P) and brokerage and clearinghouses (National Financial Services).
  • Provide detailed documentation of DBA procedures/operations, including a DBA run book focused primarily on DBA routine functions for proactively maintaining the corporate databases.
  • Performed and automated any dba tasks using shell scripting for korn, bash, Perl, Awk, sed, ps, and many more uinx/linux like utilities such tar, gunzip, gzip, backup

Environment: OLTP and DSS system DBs sized from 150Gs up to 4.1 TBs running on Oracle 9iR2, 10gR2, 11gR2, PostgreSQL, EnterpriseDB, Oracle10gAS, Oracle Exadata 2, Solaris 9/10, PH-UX, Linux Novell SuSe and Red Hat; 3PAR InServ T800, EMC Clariion X3 M80, Hitachi AMS, 500, 2100, 2300

Lead Oracle DBA/Coordinating Manager

Health & Hospitals Corporation of New York, New York, NY

Nov 2003Dec 2006

Implemented, maintained and enhanced MISYS Data warehouse, a major VLDB/WH mainly used for DSS and scientific research
  • Led deployment of the MISYS Data warehouse project for HHC at Coney Island Hospital, including partitioning implementation, performance tuning and maintenance.
  • Implemented major database technologies including Oracle SQL Server, Oracle Applications Server, Oracle Discoverer Admin and End Users.
  • Developed and administered customized reports using Oracle Discoverer and Oracle Discoverer Administrator.
  • Provided detailed documentation for all installations and database processes.

Environment: OLTPs, DDS, and WH DB systems sized up 5.7 TBs running on Oracle 9iR2/10gR2, SQL Server 2000, Oracle9iAS, Oracle Discoverer End User & Administrator, AIX 5.2, Linux, and Teradata

Oracle DBA

GlobalTron Corporation, Miami, FL

Jul 2002Oct 2003

Designed, created and administered Oracle databases (production, development and testing environments).
  • Worked with local and remote DBAs to synchronize database objects and implement backup strategies.
  • Developed custom reports, interfaces, and applications using Crystal Reports.
  • Monitored and maintained SQL Server production environment.
  • Administered security; created user accounts and managed roles, privileges and profiles.

Environment: OLTPs and DSS/WH system DBs combine sized up to 1.5 TBs running on Oracle 8i, SQLSERVER 7.0/2000, Solaris, DB2 UBC, z/OZ, AIX

Oracle DBA

Net Import & Export Inc, Miami, FL

Jan 2000Jun 2002

Assisted senior DBAs in creating/maintaining Oracle databases
  • Created and modified new and existing SQL code, including PL/SQL packages.
  • Created stored procedures, views and transactions linked to custom user interfaces.
  • Performed capacity planning
  • Resolved Oracle related errors/issues on an on-going basis.
  • Planned, implemented and monitored backup and recovery strategies for production databases using RMAN.
  • Administered company's Microsoft network.
  • Maintained the company's CRM database.

Environment: OLTP DBs running on Oracle 8i, SQLServer7, InterAction 3.22, Sun Solaris, Windows NT 4.0, NetApp

Technical Support

Computer Technical Systems, Miami, FL

Nov 1998Dec 1999

Developed and supported desktop MS Access databases for in-house and external client use.
  • Installed, implemented, and integrated accounting software systems.
  • Assisted in the installation, configuration and support of Microsoft networks and mixed environments.
  • Provided technical support via phone.

Environment: MS-Office Suite 97, MS-Access, MS-Windows NT, Unix Solaris 5.8/8, SQL Server, Oracle

Education

Information Management Systems Analyst

Tech Business School Miami, Miami, FL

2000

B.S in Computer Science

Santo Thomas University,

1999

Additional Information

Technical Skills

RDBMS/Apps: Oracle 8i/9i/10g/11g, Oracle TimesTen (11g R2), SQL Server, PostgreSQL 9.1, Oracle 9iAS/10gAS, Oracle Grid Control, WebLogic 10/11, Oracle EBS (11i/12i), EnterpriseDB (Advance server and plus), DB2
Tools: Oracle SQL Developer, Oracle Discoverer DS, OEM, RMAN, STACKPACK, Erwin, Toad, MS-Visio Crystal Reports, SQL*Loader, JDeveloper9i; Secure CRT, TOAD, Putty; Informatica, DataJunction. Oracle Apps 11i/12i, MS Project, GoldenGate, Exadata, SharePlex, IBM BDW 8.2, Spectrum, PgAdmin, PgCluster TOAD for PostgreSQL 9
Languages: SQL, PL/SQL, T-SQL, Shell Scripts, PERL, PHP, Java, JavaScript, C, C++
Operating Systems: UNIX (Sun Solaris, IBM AIX 5.X, HP-UX 11i v3), Linux (Red Hat, SuSe), MS Server,
MS Windows NT Server
Storage Vendors: 3PAR, EMC, Hitachi, IBM Subsystems, IBM Banking Data Warehouse
  • Operating Systems: Sun Solaris, IBM AIX 5.X, HP-UX 11i, Red Hat, SuSe/Novell MS Server, MS Windows NT Server
  • Other: Secure CRT, TOAD, Putty; Informatica, DataJunction, PostgreSQL, DB2, GoldenGate, SharePlex, Veritas Cluster Ware

Work Status: US Citizen
Powered by Super-Resume