Information Technology Sql

Summary:

** ***** ** ********** **************, design, Development Operations implementations and support. Strong experience in Database Administration, design, DB architect the full SDLC complaint database infrastructure with different versions (7.x to 12c). Proficient in Oracle SQL, PL/SQL, RAC High Availability, ASM, Active Data Guard, Golden Gate, Oracle Grid Control, OEM13c, RMAN, Data pump, WebLogic Setup, Cloud migrations (AWS & Oracle), Data Warehousing tools and MS SQL server 2000/2005/2008, CM Tools. Hands on experience in multiple components of enterprise IT architecture including cloud computing, virtualization, DB design and development and inter-disciplinary teamwork.

Skills :

Amazon AWS – EC2, EBS, AMIs, VPC and Security groups, S3

Oracle RDBMS Architecture: Oracle 12c, 11g, 10g, 9i, 8i. RAC 11g, 10g, Oracle internet Directories (OID)

Non-Oracle RDBMS: MySQL 5.x, MS-SQL Server, Sybase ASE 12.5.

Development Tools: Golden Gate, Streams, TOAD11.x, DB Artisan, SQL Developer, SQL* Loader, SQL, PL/SQL, T-SQL, Erwin4.x, Rational Rose, Oracle Warehouse builder (OWB), ODI.

Diagnostic Tools: DB Grid Control, ADDM, AWR, TKPROF, Explain Plan, Quest SQL Optimizer, ASMCMD, SRVCTL, SQL Performance Analyzer, ADR

Backup & Recovery: RMAN, Golden Gate, Streams, Data Guard, Data Pump, Import/Export, SQL Backtrack, Tivoli Storage Manager (TSM)

Operating Systems: AWS Cloud, Red Hat Linux 4.x/5.x/6.x, Cent OS, VMware, Windows Server 2012, Solaris 10/9/8,, AIX 5.x,

Hardware: Veritas NetBackup.

Tools/Utilities: Rational Clear Quest, Clear Case, BMC Remedy, AutoSys

Virtualization: Oracle VM 2.2, VMware Server 2.0.1

Languages: Sh, shell, K sh, Cron scheduling, Shell Programming, VBScript, Java Script

Applications: MS Project, MS-Office, CVS, Remedy, Rational Clear Quest, Clear Case, Crystal Reports 8.0

Employer Details:

Optimal Solutions and Technologies (OST Inc.) McLean, VA Dec’2016 to Current

Hcl Global Systems Inc . Farmington Hills, MI Sep’2008 - Dec’2016

International Software systems Inc (ISSI) - Greenbelt, MD Oct’2005 - Sep’2007

Accelrys Software solutions, Bangalore, India June’ 03 – Sep’05

Avesthagen Grain Technologies Bangalore, India Nov ‘00 - May ‘03

Experience:

Optimal Solutions and Technologies (OST Inc.) McLean, VA Dec’2016 to Current

Project: Federal Administration Aviation (FAA)

Role: Lead Oracle DBA

Leading & Supporting one of the main FAA systems called Spectrum Engineering and Automation Support System for FAA.

Responsibilities:

Leading 24*7 oracle 12c Multitenant Production systems.

Train & manage DB Development team

Installed OEM 13c Cloud control, WebLogic and configured Agents.

Analyze DB Designing on regular basis and provide recommendations to development team for any modifications or merge etc.

Prepare the audit reports and submit to management for any unusual activities

Developing protocols for data processing

Design, development, testing, performance tuning, deployment, and support in Data warehouse system

Migration of Oracle Databases into Amazon Cloud

Interact with FAA Customers and get the feedback about the performance and discuss any application enhancements with respect to product Licensing and renewals.

Upgrade, Implementing and managing Oracle11g/12c Active/Physical Stand by Data Guard.

Established Data guard systems for High Availability

Running AWR, ASH and Real-Time ADDM reports routinely to check for any potential database performance issue.

Monitor scheduled backup jobs (RMAN & Data Pump) on regular intervals by recreating test servers.

Created SOPs for patch installations and production deployments.

Performed many TEST/DEV/UAT Refreshes with production Data on request.

Manage production Deployments by following CMM Level 5 standards

Environment: Oracele12c/11g/, OEM 13c, Oracle internet Directories (OID),AWS Cloud, VM WARE, Red Hat Linux 9, web logic, ASM, RAC, Data Guard, Import/Export, Data pump, RMAN, SQL Loader, ADDM, AWR, TKPROF, Explain Plan, TOAD 11.x, Shell Scripts, Jira, Win-2012 servers, Ms-Project,,SQL Developer4.x, MySQL 5.x.Mango DB, Tortoise SVN, CM tools.

Employer: HCL Global Systems Inc., Farmington Hills, MI Jan-2009 to Dec 2016

Client: Dept. of Heath and Human Resources August 2011 to current

Sr. Systems Engineer (Consultant) at Administration for Children & Families (ACF), Washington, DC.

Supported Oracle 10gR2/11gR1/R2/12c Production/Test/Dev databases. All the Applications are integrated with Oracle internet directories (OID) for their enterprise customers/users to provide high level security to access the data from any location.

Actively involved in AWS Cloud migrations including AWS training, Licensing, Architecture, development efforts, application design, and QA activities.

Installed Amazon Cloud database migration efforts from VMWare Systems based virtualized environment, which includes install and configure and setup all Oracle databases, S3-RMAN backups, Oracle OID servers and Oracle Grid Control environments, WebLogic setup on AWS cloud environment.

Provided Development and operations lead role for Oracle based applications for AWS migrations.

Migration of Oracle Databases into Amazon Cloud.

Leading & supporting 24x7 Oracle production and development, administration and application Support on VMWARE/Amazon Cloud DB migrations.

Maintain Amazon Ec2 instances, AMIs, VPC networks, Security groups, S3/RMAN backups.

Installation, Configuration, implementation and Administration of Oracle 11g/12c databases,

Standby Databases for High Availability and Disaster Recovery purpose.

Upgrade Databases from 10g to 11g & 11g to 12c.

Installation, Configuration & Administration of Grid Control (OEM) & WebLogic

Install OID (Enterprise Security -LDAP) and configure to databases, create single sign-on user security policies.

Performance tuning of the database Using EXPLAIN PLAN, AWR, ADDM for the Better performance

Implement RMAN backups and Data pump backup scripts and write onto Tapes

Environment: Oracele12c/11g/10G/, Oracle internet Directories (OID),,AWS Cloud, VM WARE, SUN SOLARIS 9/10, Red Hat Linux 9, web logic, Oracle Grid Control, ASM, RAC, Data Guard, Import/Export, Data pump, RMAN, SQL Loader, ADDM, AWR, TKPROF, Explain Plan, TOAD 11.x, Shell Scripts, Jira, Win-XP, MS-Project,,SQL Developer, MySQL 5.x. Tortoise SVN.

Oracle DBA Consultant (Application and production Support DBA) June -2010 – Aug-2011

Fannie Mae, Herndon VA, USA

Oracle DBA consultant to provide 24/7 support for Oracle databases in Capital Markets of DRM & DSM services. The applications under Capital Markets are Trade/ Cash management / financial / loan / Asset market to market / Price verifications/ Stamps etc.

Responsibilities:

Performance tuning at various levels like DB level, memory and SQL application tuning using AWR, ADDM, SQL Tuning advisor.

Configure and maintain Data Guard (Physical Standby database) for the production database and tested for Switchover, fail over, activating the standby to primary and zero data loss.

Performing DB restores using Datapump/RMAN

Configure OEM, OMS and Agent on Linux servers for back office database servers.

Environment: Oracele11g/10G/9i, SUN SOLARIS 9/10, AIX 5L, Linux 9, Oracle Grid Control, RAC, ASM, Data Guard, Import/Export, Data pump, OWB, SQL Loader, SQL Backtrack, Autosys, OEM, ADDM, AWR, DBMS_STATS, DBMS_SQLTUNE, RMAN, EXPLAIN PLAN, TKPROF, DB Artisan, Quest Spotlight, Shell Scripts, CVS, Remedy, Clear Case, Win-XP, MS-Project, SQL Server 2005/Sybase ASE 12.5

Client: DHHS May-2007 to April - 2010

Dept. of Public Health Services (PSC) - Rockville, MD

Role: Sr. Oracle DBA Consultant (Production and Development)

Environment: Oracle11g/10g/Grid control/ASM/ RAC/ HP-UX /X-Windows (Humming Bird)/Windows XP/ RMAN/ CRON jobs/Shell scripting/DBCA/SQL*Loader/Data Pump/SQL/PLSQL/CVS/MS Visio/ MS Project

Client: Freddie Mac, McLean, VA May’-06 to May-07

Mortgage and Finance Industry

Role: Oracle DBA- Consultant (Production and Project)

Providing 24x7 production DBA support for maintaining the databases, backup failures, error logs monitoring space related issues related to log segment and temp tablespaces, Tuning the queries.

Environment: Oracle 9i/10g / Oracle 10g Grid control / RAC /ASM/RMAN/ Sun Solaris/ Linux / X-Windows(Hummingbird)/Win-XP/ SQL backtrack 6.0.1/ DB Artisan/ SQL&PLSQL/ shell scripting /Clear Quest/Clear case/ftp/DBCA/SQL*Loader/I MP/EXP/Oracle 10g agent/ Sybase ASE/Oracle Migration work Bench/People Soft Financials(support)

Employer : ISSI Inc.

Client: Washington Gas, Springfield VA Dec’-05 to May’-06

Role : Oracle DBA - Consultant

Supporting Mission-Critical consumer applications impact 24X7 production system.

Implemented Disaster recovery plan document

RMAN configuration & setup for Backup, Recovery Strategy and disaster recovery on Production, Dev and Test databases

Environment: Oracle 9i/10G, SUN SOLARIS 8, Windows 2000 Server, 9i parallel Server, Oracle 10g Grid Control, Data pump, Export/Import, OEM, ADDM, AWR, DBMS_STATS, RMAN, STATSPACK, EXPLAIN PLAN, TKPROF, SQL, PL/SQL, TOAD, Shell Scripts, Cron Scripts.

Accelrys software solutions, Bangalore, India June’ 03 – Sep’05

Role: Oracle DBA /product Development Engineer.

Installation, Configuration of Oracle 9i/10g database on Win-2000/AIX/Solaris

Planning Backup and Recovery Strategy on Dev, Test and Prod databases

Migrating the Database from 8i to 9i on Solaris platform

Environment: Oracle9iR2 /10gR1 / SQL & PL/SQL/ Pro*C/ Sun Solaris / Linux/ Shell/ Perl/ Toad7.x/ Autosys/ Shell scripting /OEM/ Oracle replication / SQL*Loader/ Putty/ MS Project/ MS-Office/ DB2 / ER-Studio/ Discovery Link/ DB2/ VC/VB-COM/SOAP/ J2EE/ XML/MS-Visual studio/ODBC/ ADO/ CVS /

Avesthagen Grain Technologies Bangalore, India Nov ‘00 to May ‘03

Role: Developer & DBA

LIMS administrator and data migration from MySQL to oracle using migration bench work and SQL* loader.

Analysis, Designing of database and creating tables.

User Administration, Backup and Recovery operations.

Monitoring and performance Tuning of database (Query optimization parameters for the best performance)

Environment: Oracle8i /OEM / SQL & PL/SQL, Forms and Reports, MySQL 3.2 Linux/ Unix –AIX/ PHP 4.21 and JavaScript.

Education

M.Sc. in Information Technology Alagappa University, TN - India

Bachelor of Science Andhra University – AP – India

Software engineering diploma - National institute of information Technology(NIIT)

Contact this candidate