We provide IT Staff Augmentation Services!

Ms Sql Server - Oracle Dba Resume

Miami, FL

OBJECTIVE

  • Highly Motivated, Creative, dynamic and detailed oriented database administrator professional with 6 years of hands - on experience in production and project support across full system development life cycle (SDLC). Duties include but not limited to database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, Always on replication, Dataguard, Golden Gate, RAC, log shipping, mirroring, cloning, migration, shell scripting and documentation. Experienced in multitasking, enjoys working with people and communicate effectively.

SUMMARY

  • Experienced Oracle DBA with 6years of experience in Oracle Database Administration in large-scale production environments across multiple platforms
  • Experienced DBA with 6 years of experience in MS SQL Server in large-scale production environments on windows platform.
  • Implemented SQL Server data management principles and best practices in order to properly store, migrate, and structure data for multiple applications
  • Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Real Application Clusters (RAC) and Data Guard.
  • Experienced in managing the development and performance of SQL databases for web applications, businesses and organizations
  • Conducts SQL databases troubleshooting and bug fixing on databases and applications, resolving issues without excessive downtime or data loss.
  • Experience in Performance tuning of Oracle Golden Gate Processes to achieve zero lag times.
  • I have great leadership experience, I have successfully exercised my lead experience during
  • The data Guard Configuration for disaster recovery/I assigned and monitored projects and equally wrote project reports
  • Hands on experience on using of macros, conflict resolution, filtering and transformation, exception handlers and Security.
  • Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.
  • I configured data guard for high availability, data protection, and recoverability.
  • In my current environment, our standby data guard is configured to a physical standby database and set to Maximum Performance mode.
  • I have used Service to create tickets, it equally updated me of the daily tasks assigned to me by my Manager
  • I configured a logical standby database in some of my test environments.
  • I converted some of my databases into a snapshot standby database for testing.
  • I have the ability to set the database on maximum performance, max availability and max protection mode.
  • During my configuration, I had to configure my physical standby database and managed it using OEM where I configured Data Guard Broker to manage the primary and standby databases to facilitate a fast-start failover during the fail-over. I did this so that it automatically detects the failure, evaluates the status of the dg configuration and if appropriate, executes the failover to the previously chosen standby database.
  • Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.
  • Upgrade SQL Servers and assist with transitioning applications to a newer version of the server.
  • SQL Server - Installation, Configuration, Security Standards, Performance Monitoring.
  • Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards, Database Engine Tuning Advisor.
  • Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.
  • Experience in Database capacity planning, monitoring object growth and Storage Management.
  • Performed data migration from flat files into an Oracle database using SQL*Loader.
  • Experience in performing Cloning and Refresh using RMAN and Datapump.
  • Good in gathering SQL database requirements and specifications from end users to design and structure data and grant access to users.
  • Experience in Online/Offline Re-Organization of database objects.
  • Experience in Partitioning Tables, Rebuilding of Indexes, Secure files, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
  • Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo segments, creation of database objects, Data Modeling.
  • Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.
  • Ensure that SQL Server data is intact, correct, and accessible after a server migration or backup
  • Proficient with fine grain Auditing and SQL Server Auditing for compliance purposes. Created server audit specifications and database audit specifications.
  • Assuring First line of defense: Transparently detect and block SQL injection attacks, privilege escalation, and other threats against Oracle, Microsoft SQL Server, IBM DB2, SAP
  • Faster response: Automatically detect unauthorized database activities that violate security policies, and thwart perpetrators from covering their tracks
  • Simplified compliance reporting: Easily analyze audit and event data and take action in a timely fashion with out-of-the-box compliance reports
  • Experience working with database security tools TDE, DB Vault / VPD.
  • Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.
  • Experience in upgrading Oracle Binaries and databases from 10g to 11g and 11g to 12c to 19c.
  • Proficient in writing SQL, PL/SQL (Stored Procedures, functions, packages and triggers) scripts.
  • Experience in Shell Scripting for configuring monitoring alerts and automation.
  • Experience in performing Data Migration between Non ASM and ASM databases and also between the databases of different vendors.
  • Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemas and to
  • Configure SQL servers and processes and automate tasks to improve reliability and cut down on development time.
  • Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
  • Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone
  • Migration and upgraded of SQL Server 2008 databases to MS SQL Server 2017
  • Experience in Upgrading databases, applying patches.
  • Managing Security Management, Schema Management, Instance Management, Storage/Space Management.
  • Proficient with Database Cloning, Migration, and Patching of Oracle Databases
  • Installed Oracle 11g with ASM and OCFS2 File systems.
  • Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
  • Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 12c, 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
  • Oracle application/ E-Business Suite cloning / Refresh of 11i, R12.
  • UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
  • I have implemented unidirectional and bidirectional real time replication in Golden Gate, I have also done upgrades and migration with zero downtime

AREAS OF EXPERTISE

  • Software installation and Database creation
  • Database /system Backup and recovery
  • System Monitoring and Performance tuning
  • Data management both on - premise and in the cloud
  • SQL, TSQL, PL/SQL and shell scripting
  • Server development and maintenance
  • Database/system Upgrade and Migration
  • Data and database integrity and security
  • High Availability Architecture (HA) and disaster recovery such as Oracle RAC and Data Guard
  • Golden Gate Data Replication and Always on replication

TECHNICAL SKILLS

OPERATING SYSTEMS: Red Hat Linux RHEL 7.4.x, Windows XP, Windows 10

RDBMS: Oracle 12c/11g/10g, MS SQL Server 2008/200R 2/2012/2014/2016/2017

LANGUAGES: SQL, PL/SQL, TSQL, UNIX Shell Scripting, Bash and Powershell Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), SQL Server Management Studio (SSMS), Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, SQL Developer, TOAD, Data Pump (expdp,impdp), SRVCTL,SQL*Plus, Veritas, EBS, Solar winds, Digital.AI Deploy and Vshere

TUNING TOOLS: Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards, Database Engine Tuning Advisor, SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, Visual Studio

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential - Miami, FL

MS SQL Server - Oracle DBA

Responsibilities:

  • Experienced in Migration and upgrade of SQL Server 2008 databases to MS SQL Server 2017
  • Displayed a high level of expertise while handling the various scenarios of database Backup & recovery and cloning using the RMAN tool in RAC and Data Guard environments of large to very large databases also setup RMAN catalog for the same.
  • Experienced in managing the development and performance of SQL databases for web applications, businesses and organizations
  • SQL Server - Installation, Configuration, Security Standards, Performance Monitoring.
  • Upgrade SQL Servers and assist with transitioning applications to a newer version of the server
  • Hands on experience in installation and implementation of 12c cloud control and migration of 11g grid control to 12c cloud control.
  • Tuning of Oracle Databases for performance improvement using AWR, ADDM, ASH, Trace Analyzer, SQLTXPLAIN, OSWatcher and other OS related utilities like, top, vmstat, iostat, prstat, strace, and also used Oracle Enterprise Manager (OEM) 11g and 12c to monitor single instance and RAC databases.
  • Involved in Always On for High Availability and reporting purpose and created the documentation.
  • Experienced with data architecture and management to develop and scale SQL databases based on organization’s needs
  • Performed oracle Software's Installations, Creation of new standalone and clustered databases.
  • I successfully led a team of DBAs during the configuration of a data Guard for disaster recovery
  • Administering and setting up of 11gR2 RAC and 12C RAC clusterware and instances.
  • Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
  • Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Cloned Oracle application environment from production to development and test instances.
  • Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ASMCMD,
  • Conducts SQL databases troubleshooting and bug fixing on databases and applications, resolving issues without excessive downtime or data loss.
  • Partitioned tables Maintenance, adding new partitions, exchanging one-year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
  • Implemented 11g Interval Partitioning for monthly partitioning of large tables.
  • Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
  • Experience with Logical backups EXPDP/IMPDP worked with conventional EXP/IMP for migrating data from 10g to11g
  • Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab
  • Proficient with fine grain Auditing and SQL Server Auditing for compliance purposes. Created server audit specifications and database audit specifications.
  • Designed and implemented different backup strategies like Cold, Hot, RMAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
  • Handled Chained Rows and Row migration and solved the database performance issues.
  • Experienced with ASM, adding, deleting disks from the disk group.
  • Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
  • Ensure scheduled T-SQL stored procedures, and jobs run properly.
  • Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards, Database Engine Tuning Advisor.
  • Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
  • Applied database patches using Opatch utility
  • Information Technology- Data transmission, data retrieval, data manipulation, data processing and data storage
  • I have applied patches and upgrades on Golden Gate with zero down time
  • I have implemented real time replication on a pilot project in Golden Gate
  • I have done unidirectional and bidirectional replication in Golden Gate
  • Good in gathering SQL database requirements and specifications from end users to design and structure data and grant access to users.
  • I have done schema, table, column and whole database replication in Golden Gate
  • Ensure that SQL Server data is intact, correct, and accessible after a server migration or backup
  • Developed more efficient SQL database processes for handling and accessing data, automating recurring tasks, and performing routine maintenance

Confidential - Santa Clara, CA

Oracle DBA

Responsibilities:

  • Used information management system for data processing, data storage and data transmission
  • Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
  • Installed Oracle 10g and 11gR1,11gR2 database on HP-UX 11.0, Redhat 6,
  • Applied Bug fixes patches and Quarterly Security Patches for the stand-alone databases and 2-node RAC databases with in the maintenance window.
  • Installed RAC/GRID Infrastructure on Oracle 10g,11g and worked on ASM feature of Oracle on HP-UNIX/LINUX. Worked on the ACFS file system and scheduled backup using RMAN on ACFS file system sharing between the nodes
  • Maintained a 2-node RAC environment on LINUX AS 4.0(RHEL) for the staging purpose to support the business requirements and provide High Availability.
  • Upgraded DEV/QA/PROD databases from 11.2.0.3 to 12.1.0.2
  • Upgraded the databases from 10gR2 to 11gR2 and upgrade from 11.2.0.3 to 11.2.0.4. and to 12c
  • Installed and configured golden gate for replication.
  • Managed DSS (Decision Support System) and OLTP (On Line Transaction Processing system) full life cycle projects with multiple databases at one time, biggest database around 5T
  • Responsible for Database Backup and Recovery, daily monitoring of database & network issues
  • Deployed Grid Control to monitor and manage all the databases on clients
  • Worked on the Load Balancing issues on the Server side by creating the services.
  • Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing recommendations to make database healthy and running.
  • Experience in Data Modelling concepts like Data Vault and Advance security like DB Auditing, Labeling.
  • Data loads using SQL*Loader and refresh the test environments using Data Pump export/import
  • Administering the databases using Grid Control including but not limited to Space Management, Performance Tuning, and Workload Analysis (AWR, ADDM)
  • Involved in setting up disaster recovery sites using Data Guard technology. Configuring the Physical Standby, active data guard and snapshot standby database
  • Used Shell Scripts to automate database operation and schedule jobs using CRONTAB
  • Created and managed the RAC clustered databases on Solaris and HP-UX used ASM
  • Upgraded Grid Infrastructure and Databases from 11.2.0.2 to 11.2.0.3. by creating a new home of 11.2.0.3 and relinking the binaries.
  • Working with Oracle Support to fix the production issues.
  • Involved in capacity planning
  • Providing application support to create database objects and apply database changes.
  • Worked on Database Wallet and TDE (Transparent Data Encryption) for Encrypting the Sensitive data using column encryption and tablespace encryption.
  • Cloud experience (Oracle, Aws, Azure, Google)
  • Create and manage database in Cloud
  • Backup and Recover Database in Cloud
  • Monitor the Database to check on the Health and Performance in Cloud
  • Migrate SQL Server database to an AWS RDS Instance
  • Have exposure in cloud technology (AWS/OCI). Experience in RDS and Redshifs
  • Deploy rollback & diagnoses issues in middleware environments using Digital.AI Deploy
  • Automate and configure tasks in Microsoft ecosystem using Microsoft powershare Tool
  • Involved in reporting and mining data using SSAS
  • Migrated data within the same platform using SSIS
  • Report data using SSRS
  • Server virtualization using Microsoft Hyper-V and VMware
  • Experience supporting web applications in a SAAS environtment

Hire Now