Sai Swaroop K adg0j3@r.postjobfree.com

660-***-****

SUMMARY:

ORACLE & MS SQL SERVER Production DBA with 8+ Years of database administration and development experience

Experience in upgrading and migrating MS SQL Server from lower version to higher version.

Experience in managing MS SQL Server 2017/2016/2014/2012/2008 R2/2008 and 2005 versions

Expert in Installation, configuration and maintenance of SQL Server in all versions.

Experience in setting AlwaysOn availability groups for HA and DR

Excellent T-SQL and programming skills in designing robust queries and stored procedures

Expert in Transparent Data Encryption (TDE)

Experience in performance tuning queries and Query Optimization using SQL Profiler, Execution Plan, Performance Monitor, DBCC Commands and using SQL Server latest DMV's.

Expert in fine tuning server, CPU, Capacity planning, memory, disk and tempdb for optimal performance

Experience in HA and DR with Clustering, Mirroring, log shipping and Replication technologies.

Expert in developing and planning Full, Differential and Log backup for production environment.

Experience in creating, deploying, scheduling robust SSIS/ETL packages.

Experience in MS SQL Server reporting SSRS reports.

Experience in Installation, Configuration and Managing SSRS, SSIS and SSAS.

2 years of experience in PostgreSQL database administration.

Experience with PostgreSQL 9.6+ on AWS RDS

Strong experience in ORACLE (10g RAC/11g RAC/12c/19c) on different Unix and Windows environments like - Red Hat Linux, Oracle Enterprise Linux, HP-UX, Sun Solaris, IBM AIX, Windows.

Experience in Infrastructure set up for ORACLE/SQL SERVER databases in AWS & AZURE

Experience in migration of on-premise ORACLE/SQLSERVER databases to cloud environments AWS & AZURE

Expert in Architecture of Oracle Databases 19c, 12c/11g RAC, 10g RAC with objectives of saving costs and time.

Upgraded to 19C 18C Grid Infrastructure from 12C

Applied PSU quarterly on 12c/19c GRID & RDBMS homes using opatch auto and Up-gradation of 12c databases and Implementing catalog backup from RMAN

Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases.

Experience with features such as Oracle RAC, ASM and Active Data Guard for HA and DR solutions.

Installed and configured 2, 4, 6 node RAC (Real Application Clusters) databases

Experiences in setting up Oracle GoldenGate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions.

Experience in Upgrade and Migration of oracle databases from Windows to Linux, Sun Solaris to IBM AIX, HP-UX to Sun Solaris.

Experience in full life cycle of database administration. Worked both as a Development and Production Support DBA on a 24x7 Basis. Willing to work beyond regular hours.

Successfully implemented Physical Standby database using Oracle Active Data Guard feature for High availability configuration.

Experience in Installation, upgrades, patches, TAR support. Duties included database creation, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.

Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and recovery. Logical backup using and full/ partial export/import and Data Pump.

Experience in Performance Tuning

Efficient in SQL query optimization and instance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDM, gathering statistics, pinning the objects, Running scripts.

Experience in maintaining and monitoring databases by OEM 13c/12c/Grid Control

Experience in SQL (DDL, DML, and DCL), and PL/SQL and experience in writing stored procedures, packages, functions, and triggers.

Knowledge of NetApp experience.

Experience with FTP, SFTP, SCP files on cross platform

Involved in doing Data Modeling, Data Mart, Data Warehousing, Data Transformation.

Expertise in loading data from flat files using External Tables, SQL*LOADER.

Expertise in data archive and purge methodologies using Shell, Korn and Perl scripting.

Strong analytical and problem-solving skills with ability to work within team environment and independently when needed.

Result oriented, self-motivated, Team player, ability to work independently and within a team.

TECHNICAL SKILLS:

RDBMS

Oracle 19c/12c, Oracle 11g RAC, 10g RAC, SQL Server 2008/2012/2014/2016/2017, PostgreSQL 9.6+

Tools/Utilities

RMAN, ASM, Grid Control, OEM 12c/13c, GoldenGate, SQL*Loader, SQL Server Management Studio, EXPDP, IMPDP, TOAD, VB, Informatica Power center

LANGUAGES

SQL, PL/SQL, UNIX Shell scripting, C

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM

Languages

SQL, PL/SQL, Delphi, VC++, UNIX Shell Scripting, Perl

Database Modeling

Informatica Power center, Erwin, Rational rose, Toad Data Modeller, Datanamic and start UML, ER/studio

OPERATING SYSTEMS

HP-UX, Sun Solaris, AIX, Red Hat Linux RHEL and Windows.

Other

EMC, NetApp, Veritas NetBackup, TSM

EDUCATION: Master’s in Computer Science

PROFESSIONAL EXPERIENCE:

Phillips66, Bartlesville, OK

Database Administrator SQL Server/Oracle March 2016 – Present

Responsibilities:

Providing ORACLE and SQL server database administration, application tuning, database security and production support .

Perform CORE DBA tasks such as Database Administration on Oracle 12c/19c environments, performance tuning, Schema creation, maintenance, and troubleshooting.

Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM 13c

Installed, configured and maintained Oracle 12c Real Application Cluster (RAC) / ASM on Oracle Enterprise Linux boxes.

Installing, upgrading and maintaining SQL server databases

Installed/configured and patched latest version of SQL Server 2017/2016/2014 and 2012 versions

Worked Heavily on the Installation, Configuration and Maintained SQL Server 2016/2017 on Windows 2016.

Supporting several enterprise-wide high availability systems and services with SLA driven up-time requirements

Planned and Implemented SQL Server in Microsoft Azure and AWS environments.

Configured SQL Server 2012/2014/2016/2017Always ON Availability Group for High Availability.

Planned and implemented solid full, differential and log backups for production environment

Migrated MS SQL Server 2008r2 to SQL Server 2014/2016/2017.

Worked on securing database with TDE (Transparent data encryption)

Installing and deploying SSIS packages on multiple servers

Implemented Replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for Transactional Replication.

Managed Windows and SQL Server based security authentication.

Implemented Always ON Availability for HA and disaster recovery in Production Environment.

Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.

Planning and executing database backup and recovery

Configuring log analyzation tools like pgfouine and pgbadger etc.

Installing and configuring nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.

Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community.

Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.

Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases

Upgraded Oracle databases from 12c to 19c.

Providing database tuning for performance and stability

Managing physical database design and implementation, database security implementation and monitoring.

Using change management processes to prevent production disruptions and outages.

Researching and recommending solutions that best meet business needs and Enterprise operational requirements.

Partnering with other IT organizations to ensure quality support and delivery to the end-user

This position participates in an on-call rotation with other DBA's to provide 24X7 coverage

Provide technical support and troubleshooting assistance to developers

Ensuring synchronization between production replica databases

Working on Oracle OEM 12c, 13c

Setup and manage High Availability and Disaster recovery environments to minimize the impact to business.

Provide support for infrastructure setup for Oracle and SQL server databases in AWS and AZURE

Migration of Oracle databases to AWS and AZURE using awscli and Unix tools with minimum downtime and less impact to business.

Migration of on-premise SQL SERVER databases from 2008 to AWS environments 2012/2016.

Monitor and optimize performance issues at the application and database level.

Plan, design, implement, enhance and maintain complex databases, access methods, database security, and audit & regulatory requirements

Identify root causes of production problems and work with developers to circumvent and resolve such problems

Manage and implement schema changes, including but not limited to creating/altering tables, constraints, indexes, grants, and sequences

Strong working knowledge to upgrade, maintain and Support Oracle database products in Unix environments

Meet weekly with team to discuss process improvement

Ability and willingness to work with a global support team

Environment: Oracle 19c/12c/11gRAC/10gRAC, Data guard, RMAN, ASM, GoldenGate, IBM AIX, Windows, RedHat Linux, PL/SQL, TOAD, Oracle OEM cloud 12c/13c, SQL Server 2005/2008/2012/2014/2016/2017, Clustering, Mirroring, Log shipping, Replication, SSIS, SSRS, SSAS, T-SQL, SQL- Developer.

ConocoPhillips, Bartlesville, OK June2012 – March 2016

Oracle DBA

Responsibilities

Support production databases on 24x7 on call basis.

Installation and configuration of Oracle 10g RAC, 11g RAC databases.

Upgraded databases from 9i to 10g, 11g and 10g to 11g

Migrated databases from Windows to Linux, HP-UX to Sun Solaris.

Cloned databases for development and testing from production

Developed UNIX shell scripts for backups, monitoring for alert log messages, purging log files, tablespace growth etc.

Partitioned large table for better performance and manageability

Implemented Oracle Grid Infrastructure & ASM

Moved existing databases running on traditional storage to Oracle ASM

Implemented Physical Standby Database (Active Data Guard) for Disaster Recovery and Reporting purpose

Create and Manage user, table spaces, datafiles and archive log.

Monitor, tune and maintain overall database.

Written PL/SQL programs, Functions, Procedure, Packages and Triggers

Create and implement backup and recovery strategies using RMAN incremental backups.

Provide troubleshooting and problem-solving support to application developers.

Support the development staff for implementation of database objects.

Schedule jobs in crontab including RMAN backup and other maintenance routine jobs

Tune and optimize SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the AWR and ADDR report generated from snapshots taken at the peak business hours.

Performance tuning and Monitoring using OEM/Grid Control.

Data loads using SQL*Loader and External Tables

Applied CPU patches and other patches as required.

Logical and Physical Database design

Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).

Writing UNIX shell scripts for backup and recovery, Import and export procedure.

Involved in Applications 11i administration including 11i Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.

Environment: Oracle 11g RAC/12c, RMAN, ASM, SQL*Loader, HP-UX, Sun Solaris, RedHat Linux, Windows, TOAD, SQL*Plus, Oracle Enterprise Manager 12c/Grid Control

Contact this candidate