SUMMARY:

• Overall 12 years of cross - platform experience in Database and Linux/Unix Systems Administration and Security in - LINUX, UNIX, Windows and VMware ESX environment.
• 10+ years combined experience as an Oracle/Mysql/MS SQL DBA including installation, upgrade, configuration, backup, troubleshooting, performance turning in a Linux and Windows environments.
• Experience with continuous development and deployment to Amazon AWS Cloud
• Experience deploying highly scalable and fault-tolerant services within public and private cloud infrastructure (AWS, MS Azure, Oracle Public Cloud, SAAS, IAAS, PAAS, VMware)
• Expert level experience with AWS DevOps tools, technologies and APIs associated with IAM, CloudFormation, AMIs, SNS, EC2, EBS, S3, RDS, VPC, ELB, IAM, Route 53, Security Groups, etc.
• Experience designing and building web application environments on AWS
• Proven ability to manage database infrastructure in AWS (RDS and EC2)
• Linux/Unix System Administration experience - RedHat, Ubuntu, AIX, Oracle Solaris
• Experience with deploying configuration management and CI/CD services such as (Chef, Ansible,Power shell, Jenkins, Vagrant, Docker, JIRA)
• Experience in other public clouds such as MS Azure, Oracle Public Cloud, VMWare
• Hands-on experience migrating Oracle, SQL Server instances to AWS
• Experience installing, configuring, and maintaining services - Bind, Apache, MySQL, nginx, LAMP etc
• Strong hands-on background in database technologies (Oracle RAC, Mysql, MS SQL, DynamoDB)
• Hands-on cloud migration solution design experience
• Knowledge of IT security principles, continuous Integration and Deployment experience
• Proficient in “High Availability” concepts including database recovery procedures, HA design and effective disaster recovery planning
• Experience understanding networking concepts for example VPN, PKI, IPSec
• Deep technical knowledge of several monitoring and analytics tools such as Nagios, Splunk, and AWS Cloudwatch
• Thorough understanding of IAM solutions, SSO, Federation & STS to deliver secure cloud services interaction and environment access
• Experience with web deployment technology specifically including Linux, Apache, Tomcat, and Java.
• Solid experience deploying and managing enterprise Fusion Middleware applications - Weblogic, OAM, OIM, OID, OVD, GoldenGate, Oracle RAC DB and Oracle eBusiness Suite knowledge of Oracle 10g/11g/12C Database, RAC/ASM/HA and Data Guard environment
• Experience with implementing/maintaining database security, applying STIGs and CPU/PSU patches
• Good knowledge of security management, auditing methodology and technology risk assessment
• Experience with requirements of the Federal Information Security Management Act (FISMA)
• Demonstrated knowledge of NIST security controls and corresponding frameworks
• Strong working knowledge of storage environments (SAN, NAS)
• Experience working with all phases of the software development lifecycle (SDLC).
• Familiarity with Agile Development Methodology
• Experience installing, upgrading and managing Oracle Fusion Middleware environment, including Oracle Weblogic server 10g/11g, OIM, OAM,SOA, LDAP, OUD, OVD, ODSEE and OID
• Ability to participate in off-hours on-call rotation and provide 24x7 support

TECHNICAL SKILLS:

Cloud & SaaS Platforms: AWS (EC2, S3,EBS, AWS Directory Service for MS AD, advanced AWS security, Lambda, IAM, RDS, VPC,NAT, VPC peering, High Availability, Auto-scaling, Cloudfront, Route53), Oracle Public Cloud, Oracle 12C OEM, MS Azure, VMWare

AUTOMATION:: Ansible, CHEF, Powershell, Unix Shell scripting, SQL, PL/SQL, MCollective

Oracle Database:: 9i/10g/11g/12C, 12C OEM,RAC, ASM, DATAGUARD, RMAN, Performance Tuning (AWR, ADDM), Oracle Security/Access Control, Oracle CPU, Oracle RAC, DBCA, OUI, RMAN with NetBackup

MS SQL: MS SQL server 2000/05/08 Administration, SSIS, SSRS, SSAS

Fusion Middleware: Weblogic, OIM, OAM, OID, OVD, LDAP, ODSEE, OUD, SOA, BPEL

Compliance/Standards: CoBIT 4.0, FISMA, HIPAA, NIST 800- 53, 800- 53A, 800- 37, 800- 18, FIPS 199

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Cloud Solutions Engineer (Systems/Database)

Responsibilities:

• Responsible Designing, implementing, and maintaining highly available, scalable, and self-healing systems on the AWS platform
• Responsible for configuring/migrating RDBMS across AWS availability zones for availability, performance and disaster recovery
• Responsible for Building out and improving the reliability and performance of cloud applications and cloud infrastructure deployed on Amazon Web Services
• Responsible for Installing Oracle 10g/11g/12C Database and performing upgrade, administration, tuning, backup and recovery of large multi-terabyte DB
• Responsible for backing up the cloud and on-premise resources, including the hybrid environment
• Create gold images and employ load-balancing and auto scaling
• Develop information security policies, procedures / standards required to design cloud based solutions
• Work with Jenkins for parameterized, upstream/downstream build Automation
• Work with Developers on tools like Vagrant and Docker - for building and deploying applications on cloud environment
• Responsible for for Agile and project management and tracking by using tools like JIRA
• Build backup/restore and DR solutions for the database stack in AWS
• Install patches and updates as appropriate on production, development, test environments and staging environments in both Cloud and on-premise environments.
• Deployed configuration management scripts in Ansible, PowerShell, bash, Python, SQL to automate database deployment, maintenance, and updates in the AWS cloud
• Supports the migration of database applications from current hosting ("as-is") to new AWS hosting ("to-be") environment
• Responsible for administration, configuration, troubleshooting and support of server environments running under various Operating Systems including Solaris, Linux (Redhat, Ubuntu) and AIX.
• Perform regular day-to-day Systems Administration activities such as User Administrations, Disk Management, Package Install, Patch Management, Storage Management, NFS Administration and disaster recovery/fail-over exercises.
• Responsible for creating IAM users and groups
• Interface with different departments within the organization regarding new deployments
• Participates in the building of the next generation of web applications and systems infrastructure, focusing on automation, availability and performance
• Recommends, plans, designs, builds, document and deploy middleware infrastructure upgrades
• Create Amazon Virtual Private Cloud (VPC) resources such as subnets, network access control lists, and security groups
• Deploy, test and document development, pre-production, and production environments
• Collaborate with Developers, DBA, Application, Security, and NOC teams on designing scalable and highly available cloud-network infrastructure platforms
• Responsible for MS SQL Server (2014/2012/2008/ R2,2005) installation, configuration, Clustering, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Work with product owners to understand desired application capabilities and testing scenarios
• Perform root cause analysis on production issues and determine action items for prevention and resolution.
• Responsible for monitoring, tuning and troubleshooting of Oracle database, RAC, GoldenGate and other middleware stacks.
• Ensure Oracle Access Manager (OAM), Oracle Internet Directory (OID), and Oracle Identity Manager (OIM) products are implemented and maintained according to customer requirements.

Principal Consultant (Database/System)

Responsibilities:

• Manage, deploy and install Oracle databases on RAC and non-RAC hardware
• Provide Database Administration support for business critical applications in production and non-production environments.
• Setup and manage AWS EC2 instances using both command-line and AWS management console
• Work with infrastructure provisioning tools such as Chef, MCollective1/2, and Puppet
• Performs troubleshooting of complex technical problems relating to infrastructure and applications.
• Performed troubleshooting of app servers (weblogic, JBOSS, Tomcat, and Glassfish) and performance issues in production and non-production.
• Implemented and administered of mission critical Cloud and VMware ESXi infrastructure
• Responsible for Unix Systems administration, configuration, troubleshooting, upgrades and support in heterogeneous server environments running under various Operating Systems including Red Hat Linux, Oracle (Sun) Solaris.
• Installed, configured and support Weblogic Application Servers 9.x, 10.x, 11g on UNIX/AIX in multi domain environment for multiple applications
• Installed and supported server operating system, system management software and operating system utilities.
• Managed the operating system configuration including initial server configuration, modifying configuration files, system configuration documentation and access to system configuration files
• Responsible for the installation and configuration of Oracle Fusion Applications Releases
• Maintained Load balancing, high availability and Fail over for the weblogic servers
• Sets up Oracle 12c Enterprise Manager for monitoring Weblogic applications and databases.
• Responsible for configuring and backing up database using RMAN, Hot, Cold and Logical backups
• Provides best practices and methods for rapid migration of databases and file structures to the AWS
• Handles space related issues on tablespaces and storage related issues on file systems.
• Optimization and tuning SQL queries using sql trace, TKPROF, explain plan, AWR/ADDM, ASH
• Responsible for the Oracle Cluster ware installation/administration/deployment - ASM administration and RAC installation/administration/deployment
• Responsible for monitoring servers and databases utilization on daily basis by using OEM report, SQL and Shell scripts to gain 100% Uptime.
• Implement and maintains oracle Active DATAGUARD (both logical/physical) databases
• Responsible for analyzing ADDM, AWR and ASH reports and troubleshooting performance issues with advisors like SQL Tuning, SQL Access, and Memory advisor.

Confidential

Sr. Principal Oracle Database Engineer

Responsibilities:

• Maintains upgrades and administer over 300 production database sites including RAC databases for the Military Medical Departments on the Defense Medical Logistics Standard Support program.
• Installed, configured and managed Oracle Fusion Middleware components on Weblogic servers
• Provided primary Weblogic administration, configuration, and troubleshooting of the web environment and performance issues
• Responsible for the installation and configuration of Oracle Access Manager (OAM) and Database Repositories schemas using RCU.
• Responsible for installing, configuring, patching, upgrading Oracle db instances and RAC DBs
• Installed and configured Oracle GoldenGate 11g Release 2 with patchset 11.2.1.0
• Work with IA and Security Teams in running the DBSRR scripts and completing DBSRR and DRW documentations for STIG requirements and maintaining database security
• Migrated RAC databases to new SAN environment and upgraded from 10G to 11G R1/R2
• Performed export/import using Data Pump (Imp/Exp) from one database to another per requests.
• Responsible for database backup strategy, restore and recovery using RMAN, imp/exp utilities.
• Responsible for performance tuning, profiling, troubleshooting and issue resolution across complex Oracle 11g RAC and non RAC environments, ASM, Oracle 10g and 11g (R1/R2).
• Monitor databases using tools like SQLPLUS, TOAD and Oracle Enterprise Manager Grid Control
• Responsible for the implementation of Database Encryption, Security and Auditing, Capacity Planning for databases, servers and storage and provide 24x7 on-call rotation support
• Responsible for working on Oracle RAC 11gR2 install scripts for Linux and Windows server 2008.
• Implemented and managed GoldenGate components - Extract, Replicat, Manager, Trails and others
• Resolve critical business issues by providing technical expertise for Oracle RDBMS, including RAC, Data Guard and other underlying infrastructure technologies
• Responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
• Performed Platform-Specific Oracle RAC Installation, Configuration and administration.

Sr. DATABASE ADMINISTRATOR

Responsibilities:

• Maintain upgrades and administer over 160 production database sites for The Military Medical Departments on the Defense Medical Logistics Standard Support (DMLSS) program.
• Configured Weblogic Server clustering and setup Node Managers and Admin Servers.
• Worked with Developers for database development including reviewing stored procedures
• Worked with other Teams and Stakeholders to analyze requirements and defines specifications for database access, structure, functional capabilities, documentation and security.
• Responsible for planning, installing, building, managing, supporting, configuring and testing Weblogic infrastructure components and connectivity
• Provide database maintenance activities including database reorganizations, backup and recovery, space management, performance tuning, and change management.
• Manages database users, roles, privileges and access in Test and Production environments
• Responsible for reviewing database security vulnerabilities and Critical Patch Updates
• Responsible for proactively monitoring the database systems and ensure minimum downtime
• Developed and maintained standard solutions for database patching, monitoring, management, migrations, upgrades and technical refreshes
• Responsible for handling problem escalation with Oracle/vendors as appropriate
• Configure and build heartbeat monitoring in Golden Gate for GL validation
• Implemented and enforces security for all Oracle Databases.

DATABASE / SYSTEMS ENGINEER

Responsibilities:

• Responsible for Configuring RMAN and performing backup and recovery processes
• Performed the installation and configuration of both Oracle and SQL Server Databases
• Responsible for Oracle RAC implementation Data Guard setup, tuning, and failover
• Developed cron tab jobs for Weblogic log file archiving.
• Provided System Administration and maintenance support on Linux enterprise system.
• Worked with Weblogic Application servers to install, configure, troubleshoot, backup and restore.
• Performed daily incremental and weekly full backups using VERITAS NetBackup and Backup Exec
• Responsible for performing all IT systems validation (FISMA Controls)
• Performed Security risk assessments in accordance with federal guidance in NIST (800-30,800-53)
• Developed and revise security plans, plans of action and milestones (POA&M), and artifacts
• Assisted in updating Information Security Policy (ISP) and Systems Security Plan (SSP)
• Administer database instances, Oracle RAC databases and ASM.
• Responsible for Using SRVCTL to administer Oracle RAC instances, databases, services, and so on
• Administered and support large multi TB production databases in Unix and linux environments
• Played a key role in ensuring the availability, performance and security of the databases
• Managed Data Guard environment for high availability, data protection, and disaster recovery
• Provided Database technical support for Oracle and SAP instances, analysis and design.
• Developed scripts to automate routine and repetitive database administration tasks
• Perform routine checks and setup on all nightly jobs on all databases
• Perform database maintenance requests from Server Support and other teams

ORACLE DBA / SYSTEM ADMINISTRATOR

Responsibilities:

• Created and maintained all databases required for development, testing and production purposes.
• Responsible for creating and managing high availability environment using Oracle RAC, Data Guard, 10g Grid, RMAN, Flashback Query, ASM, OEM, Configuration and Provisioning Pack.
• Performed daily incremental and weekly full backups using VERITAS NetBackup and Legato
• Provided Linux/Unix systems administration support on Oracle server environment
• Set up WebLogic domain with a single Server instance for developers on their windows machines.
• Responsible for installation and configuration of Weblogic Servers and Identity Management software
• Responsible for monitoring and tuning performance in Oracle RAC
• Responsible for Configuring Recovery Manager and performing backup and recovery processes
• Installed, configured and administered Oracle products such as RDBMS, RAC, Grid Control
• Worked with management to assist in implementing and enforcing security policies.
• Planned and implemented backup and recovery of the Oracle database.
• Responsible for Patching and Maintenance of Oracle Application Environments.

DATABASE/ LINUX SYSTEM ADMINISTRATOR

Responsibilities:

• Responsible for the upgrade of Oracle products and databases to latest release
• Responsible for System performance monitoring and troubleshooting
• Maintained Linux shell scripts on performance monitoring and system maintenance
• Installed new versions of the Oracle RDBMS and its tools, upgrade to newer versions
• Responsible for Database installation, upgrade, patch, configuration, backup and maintenance
• Provided Database support for critical applications in production and non-prod. environments
• Monitored all database environments by providing 24x7 rotation supports and as needed
• Developed documentation to support ongoing database development, change control, production
• Maintenances and DBA tasks. Provided configuration management, inventory management, fault management, and trouble management support on already established servers.
• Assist with database migrations, disaster recovery scenarios, and server upgrades
• Implemented physical database changes, performance tuning on Oracle partitioned environment
• Implemented best practices utilizing Oracle database technologies and implementations.

SYSTEM ENGINEER

Responsibilities:

• Responsible for administration, configuration, troubleshooting and support of server environments running under various Operating Systems including Solaris, Linux and AIX.
• Responsible for Unix Systems administration, configuration, troubleshooting, upgrades and support in heterogeneous server environments running under various Operating Systems including Red Hat Linux, Oracle (Sun) Solaris.
• Responsible for installing, configuring and maintaining IBM p Series, x86 and SPARC Servers including virtualized servers.
• Perform regular day-to-day Systems Administration activities such as User Administrations, Disk Management, Package Install, Patch Management, Storage Management, NFS Administration and disaster recovery/fail-over exercises.
• Responsible for MPIO/DMP configuration for SAN disks using native OS or third party EMC Power path, VERITAS MPIO drivers on Linux and Solaris Servers.
• Performed tasks involving complex batch job schedules and multiple priorities and action plans.
• Provided Administration and maintenance support on Linux enterprise system and other servers
• Troubleshoot VPN and RAS configuration and connectivity problems for remote users.
• Performed back up, file replications and script management for all servers