We provide IT Staff Augmentation Services!

Senior Oracle Dba / Sql Server Dba Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • A Senior Oracle and SQL Server DBA offering 25+ years of experience supporting business solution software and analyzing business operations. Aiming to utilize my strong prioritization skills and analytical ability to achieve the goals of your company.
  • Experience on architecture, design, security, tuning and implementation of databases for Banking, Automotive, Telecommunications and Financial Industries.
  • Involved in coordination of distributed teams (Developers, Project Managers and Customers) to increase productivity and reduce turnaround times. Great experience working with customers and managing projects and implementing our products at the customers environments. Assist customers during their testing process.
  • Seeking a position where my experience and capabilities can be used to contribute to a company's objectives.

TECHNICAL SUMMARY:

  • Oracle Expertise from 7 to 12c
  • MS SQL Server Expertise 2008R2, 2012, 2014 and 2016
  • Minor MySQL experience
  • Linux (Red Hat, Mandrake, SUSE, Oracle Enterprise Linux)
  • HP - UX, AIX and Solaris
  • Windows NT 4.x/ XP / 2000 / 2003 / 2008 / 7 / 2012
  • Oracle Enterprise Manager (OEM) / Grid Control
  • DBA Tools (like TOAD, SpotLight, AlertView, SQL Developer)
  • Designer Tools (like ERWin, ER Diagram, Visio)
  • SQL Loader, Import and Export data (impdp/expdp)
  • Replication and Data Guard (Standby) databases
  • RMAN, Backup and Recovery
  • Tuning, ASH, AWR, Statspack. SQL Profiler
  • RAC, Oracle Cluster
  • Agile / Scrum Methodologies / Jira
  • Vmware (Virtual Environments), AWS (Amazon Web Service)
  • SQL, PL/SQL and T-SQL
  • Unix Shell Scripting (Korn and C-shell)

EXPERIENCE:

Confidential

Senior Oracle DBA / SQL Server DBA

Responsibilities:

  • Responsible for configuration and maintenance of Oracle and SQL Server databases over Windows Servers. Apply patches and service packs to keep the database at current patch level. Developed packages to extract, transform and load (ETL) data into both databases.
  • Provided 24x7 Production support for the database and application issues.
  • Works with vendors, users, applications developers and management to obtain information and develop an understanding of the needs of the organization and to overcome significant operational and/or technical issues or problems. Reviews and approves the design of physical data models and structures
  • Provides advanced level database management, support and assistance
  • Collaborates with and supports data architects and application developers in the physical design of databases
  • Implements the physical database design and optimization strategies Analyzes, develops and supports disaster recovery plans
  • Provides back-up and recovery procedures as needed for all production and test databases
  • Provides technical consultation to the development staff and other IT organizations or groups
  • Monitors and tunes database performance to meet performance objectives
  • Manages and monitors storage capacity Provide Security to the company over the Oracle databases using Advanced Security Options, YDE (Tablespace Data Encryption) and Database Vault. Supports operations staff with their production databases

Environment: s: Dell Boxes and Virtual Servers, SQL Server 2008 R2 up to 2016, T-SQL, PL/SQL, Oracle 12c, Grid Control (OEM), Active Dataguard.

Confidential

Senior Oracle DBA / SQL Server DBA / Database Architect

Responsibilities:

  • Identify, monitor, recommend, and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity
  • Implement physical database changes, testing, and performance tuning.
  • Maintain Oracle SQL and PL/SQL scripts, Unix Shell Scripts, debugging and tuning
  • Implement Production Control and Change Management.
  • Ability to pro-actively understand and manage end user/customer expectations.
  • Provides best practices on new technologies and implementations.
  • Great experience applying patches and performing DB Migrations.
  • Plan and Design Backup/Recovery solutions using shell scripts and RMAN.
  • Ensure that the database software infrastructure is in place and up to date to support other infrastructure components (e.g., operating system and hardware) and application development.
  • Provides technical consultation to the development staff and other IT organizations or groups
  • Maintain more than 25 databases in-house for development/QA and 6 PROD databases for our customers.
  • Work on Physical OS Environments and Virtual Environments.
  • Develop and Support Strategies to provide Remote DBA Services to our customers like Federal Reserve Bank, HSBC, Bank of New York, Bank of America, JPMC, Capital One, PNC Bank, TD Bank, etc.

Environment: s: Oracle 8i to 12c. Linux, HP, AIX, SUN Solaris, Windows, PL/SQL. RMAN, RAC, Dataguard (Standby), Grid Control (OEM), Enterprise Manager. SQL Server 2008R2, 2012. Amazon EC2 (Virtual).

Confidential

Senior Oracle DBA

Responsibilities:

  • Install ORACLE software, install patches, create, tune, and upgrade databases.
  • Design of backup/recovery strategies.
  • Improve recovery process using Replication, Backup/Recovery (operating system and RMAN) and Standby Databases.
  • Review and enhanced instance cloning techniques.
  • Implement monitoring scripts for critical applications functions.
  • Tune SQL and database parameters; balance I/O.
  • Partitioned tables and indexes. Identify and resolve redundant indexing.
  • Make selected changes to improve security, recoverability, and ease-of-use.
  • Assist Developers in tuning SQL and acquiring skills with Oracle.

Environment: s: Oracle8i, DBA Studio, HP, SUN Solaris, Windows, PL/SQL.

Confidential

Oracle DBA and UNIX Administrator

Responsibilities:

  • Execute general system administration duties on Sun Solaris and HP-UX platform (like administrate disks and users, install several applications)
  • Automated DBA tasks utilizing UNIX shell scripts.
  • Tune databases queries and optimizes physical storage access.
  • Maintain database security, user roles and access profiles.
  • Install, upgrade and maintain Oracle Products and third-party software
  • Administer database backup procedures and recovery.
  • Document DBA procedures and standards.
  • Maintain database security, user roles and access profiles.
  • Perform capacity planning and sizing for new database applications.
  • Patch administration, security, and Y2K Compliance.
  • Support application developers with schema design and SQL performance tuning.
  • Provide DBA support to QA.
  • Modify database structure, as needed by application evolution.
  • Install and maintain Oracle Web Application Server 3.0 and 4.0, Apache Server and web applications.

Environment: s: NT 4.0, Oracle 7.3.4, 8.0.4.2 and Oracle8.1.5, Oracle Enterprise Manager, Oracle Web Application Server 3.0 and 4.0, Apache Server, Forms 4.5, Reports 2.1, ‘C’ Files, PL/SQL, SUN Solaris 2.5.1, HP-UX 10.20 and 11.00.

We'd love your feedback!