SUMMARY:

Seeking a challenging and innovative position in a heterogeneous MPP Database Management Systems environment in which I will be responsible for the Engineering, Setup & Configuration of AWS - Cloud Infrastructure, Systems & Software IT Architecture, IT Infrastructure and Security Compliance activities to develop scalable & reliable data solutions moving data across systems in real-time.

TECHNICAL SKILLS:

PLATFORM: SUN Solaris 10 & 11, Linux (RHEL) Enterprise 5.8 & 6.0, SESU Linux 10, Ubuntu 16, HP-UX 10.x, Windows 2000/2003/NT server, VMware ESX 4.0

Version Control: CVS, MKS Toolkit

DATABASE: Oracle 9i/10g/11g/12c, Microsoft SQL Server, MySQL, Postgres, GreenPlum DB

APPLICATION: Apache, WebSphere, Web/eCommerce, ERP, CRM, & SAS, Drupol

MONITORING: CloudWatch, CloudTrail

Appliance Provider: CloudForms, Ansible Tower

Issue Tracker: Jira, Remedy Ticket

vCLOUD: AWS

AWS Technologies, Components & Services: CloudFormation, Auto-Scaling, CloudForm, Route 53, S3, RDS, VPC, CloudWatch, SQS, SNS, IAM, AWS Config

Issue Trackers: Jira, Remedy Ticket

PROFESSIONAL EXPERIENCE:

Confidential, Crystal City, VA

AWS Architect

• Responsible for designing & developing automation work-process using Puppet & Ansible
• Performed extensive migration of all life-Cycle Systems within the Environment from On-Premise Solutions to Amazon AWS Cloud-based environment
• Actively setup & configure the AWS Cloud Infrastructure environment setting up the VPC, availability zones (AZ), AMIs, EC2 Instances, and integrated with the Security Group, Route53, IAM Roles and RDS connections.
• Setup LAMP for local & cloud-based development & image creation
• Setup, Configured and Maintained RHEL satellite server and brings updates as required
• Actively automate provision of AWS EC2 Instances using private hardened AMIs & baseline
• Responsible for maintaining the integrity & security of systems by creating & managing SECURITY Groups and Network ACLs to ensure controlled access to Instances & Subnets respectively
• Responsible for the Installation and Configuration of LAMP, Java, GIT, JENKINS, Tomcat, MySQL & Apache through ANSIBLE and environment security hardening
• Created, configured and ensured connection to RDS database running Oracle & MySQL engines
• Provided client with the right architecture and efficient decision to build highly available & scalable Web Application
• Performed system engineering support for over 400 EC2 Instances hosted in AWS Commercial Cloud as well as GOV Cloud environments
• Setup & Installation and of AD/IPA/LDAP and Configuration of all USERs to integrate with IAM Role Access on all AWS VPC & EC2 Instances
• Setup, Installation and Configuration of Trend Micro & Cloud Connector for Deep Security & Permission for IAM Role on AWS Cloud VPC & EC2 Instances.
• Setup & Configured Route 53, S3 Buckets and performed monitoring using CloudTrail, Nagios & Cloudwatch
• Created, configured and ensured connection to RDS database running Oracle & MySQL engines
• Tasks Automation experience using ANSIBLE, Puppet and SHELL scripting to automate process
• Worked with Compliance & Information Security teams on Vulnerability assessment, discovered Vulnerability and applied remediation while maintaining the integrity and secured the systems by creating Security Groups & Network ACL to ensure controlled access to Instances & Subnets
• Performed system checks on Oracle SUN Solaris, Linux RHEL & Windows servers within the infrastructure and applied Patches using Ansible Playbooks called through Ansible Tower
• Perform a strategy using AWS Identity and Access Management (IAM) Role for community platform systems and successfully implemented the same setting precedence for other teams to follow

Confidential, Lanham MD

Greenplum DBA / Oracle DBA

• Greenplum version 4.0, 4.2, 4.3.1, 4.3
• Responsible for the performance, integrity, backup and security of Greenplum Databases.
• Creating External table and copy using the single row error isolation feature.
• Ran Analyze after a data load so the query will have the most up-to-date statistics.
• Ran Vacuum to reclaim any wasted space after a data load.
• Table Partitioning to address support for very large tables.
• Backup automated with GPCRONDUMP (gp dump, pg dumpall)
• Tuning SQL formulation, database parameters, table design and data distribution when performance is not acceptable.
• Tracking performance issues using pg stats activity, pg locks, and pg class.
• Tracking performance issues in UNIX using PS, top, istat, VMstat and NETstat.
• Greenplum server log troubleshooting using gplog filter.
• Running a parallel backup by using gp dump, gp restore and gpcrondump commands.
• Installation and configuration of Greenplum full-rack DCA and database.
• Management of query processes via GP command Center.
• Proficient in use of data domain for backup and recovery of GP databases.
• Experience with Linux and shell scripting for maintaining and administering GP DCA.
• Periodic use of vacuum and analyze to optimize psql query and database efficiency.

Oracle DBA

Confidential

• Responded to database events including resource management, performance monitoring of cluster administration, managing high-availability, scaling VLDB, database recovery, and distributed partitioned database design.
• Reported of AWR, Alert logs, Oswatch archives and Daily stream lag study and analysis of the electronic filing databases.
• Established Standard Operating Procedures for the Database and application support teams.
• Performed grid control monitoring and maintenance of all 11g databases.

Confidential

• Executed Oracle database conversion to Greenplum EMC database.
• Created and managed scripts for internal and external table creation in Greenplum database.
• Monitored Greenplum databases and servers.
• Managed roles and privileges in Greenplum database.
• Loaded data in Greenplum database.
• Defined database performance using optimization, contention and workload.

Confidential, Reston, VA

Greenplum DBA / Oracle DBA

• Played lead technical role in maintaining or modifying database(s) in production
• Tracked system availability, uptime, and performance and also Confer with less experienced DBAs and guide their efforts in maintaining databases
• Coordinated with application development staff and project management staff regarding project planning, resource allocation, task definitions and schedules for substantial projects involving database(s)
• Planed and design database changes necessary for data conversion, tool configuration, data refresh or migration or other initiatives related to large application development project
• Responsible in Set up/Configuring Master, Standby and Segment Nodes, Manage Oracle Compatibility Functions, Database Extensions, and Data Storage Areas
• Backup automated with GPCRONDUMP (gp dump, pg dumpall)
• Tuning SQL formulation, database parameters, table design and data distribution when performance is not acceptable.
• Responsible for Security and Authentication including Manage Connection, Authentication Parameters, and Client Connection Default Parameters
• Determined more efficient ways of collecting and qualifying data.
• Tracking performance issues using pg stats activity, pg locks, and pg class.
• Troubleshooting errors on production problems involving databases to determine causes and proposed solutions
• Set and document standards for use of databases with objectives of data integrity, data security, efficient operation, audit requirements, and the like. Communicate to others in development or database administration roles.
• Confer with managers in networking, systems operations, applications, and client/user community to maintain stable and efficient operating environment for database(s)
• Provided technical lead, project leadership and staff supervision in large development, migration, testing, acceptance or product rollout project.
• Set up and configure database Mirroring, Log shipping, Replication
• Automate maintenance jobs, install services patching
• Proactively monitor, tune and improve Database Performance
• Identify problems, find root cause and perform tuning to ensure application performance
• Manage database Capacity growth, write stored procedures
• Build database Triggers and Referential Integrity Constraints to implement business rules
• Maintain & manage Database security, install monitor tools on the Server
• Import and export data in SQL Server Data Pump utility
• Manage User security in SQL Server 2008R2 and backup database

Confidential, Washington DC

Oracle DBA

• Provided expertise in compiling, arranging, storing and retrieval of information to facilitate support of an FAA customer, project or program
• Installation of new versions of the Oracle RDBS and migration of databases when needed, backup/Recover database files and objects
• Implemented security for all of the databases
• Provided technical support to application development team; administer all database objects and users
• Troubleshoot any problem with application, database, application server and any development tools
• A team player with the ability to work under time sensitive deadlines. Strong ability to multitask
• Administered, installed and monitored database and application server environments for both development, testing and production systems
• Performed monitoring/proactive and reactive tuning/troubleshooting of Oracle systems running off: UNIX, Linux, and Windows NT/2000/2003 servers
• Created and maintained all databases & application servers required for development, testing, training and production,
• Performed ongoing tuning of the database instances, configure, tune and optimize application servers, databases, applications
• Provide support in accessing, manipulating, and preparing data within database, investigating data structures, and analyzing data to attach meaning and value.
• Evaluated Oracle new releases/patches and its tools and ensure that the site is running the products that are most appropriate
• Designed and implemented Oracle streams on Oracle 10g for my clients between the DR and the production database
• Performed daily incremental backup and full weekly backup using Oracle backup utility RMAN
• Responsible for making sure that the servers meet FAA SCAP security standard
• Real time data replication from source database to destination database using Oracle streams
• Schedule jobs using various Oracle tools such as Oracle OEM, DBMS JOBS and SCHEDULER
• Maintained stored procedures, functions, triggers, packages and views used by the database instance
• Documented database structure, changes, problems, issues for future reference
• Develop and enforce database related policies, standards, naming conventions, operating procedures and best practices.
• Develop a strategic plan for the database development that supports the organizations operational requirements.
• Knowledge and understanding of Real Application Cluster (RAC) and Data guard.
• Used ETL tools to load data from external sources into Oracle databases.
• Used SQL statements to create scripts for automating tasks and functions, to monitor and resolve database performance issues and to troubleshoot and tune SQL statements running against databases

Confidential . Washington DC

Application Development DBA

• Analyzed and reviewed existing and proposed database architectures and provide expert support and input.
• Planned, designed, implemented, maintained and upgraded Oracle databases.
• Installation and maintenance of Oracle Internet Directory and application servers.
• Created databases, configuring them to meet developer and user requirements
• Tuned database to ensure acceptable level of performance and availability
• Installed client side of Oracle on developers and end-users PC and configuring them with network connections
• Assist in developing, updating, and maintain relational databases
• Provide assistance in developing PL/SQL procedures including running test queries, troubleshooting database problems etc.
• Advised customers on new database features, and leading studies to evaluate the effectiveness of current database methods and procedures, investigation of issues arising from data loss and corruption
• Solid experience in disaster recovery, routine maintenance for Oracle databases
• Created tables and views for developer and client needs
• Managed and maintained the data dictionaries
• Performed daily incremental backup and full weekly backup using Oracle backup utility RMAN
• Maintained database log and audit files.
• Monitored database performance using OEM. Also, run and evaluate diagnostic reports using AWR and ADDM.
• Enforced proper database access methodology practice.
• I was responsible for building and deploying application WAR files developed by the developers to fix bugs.

Confidential, Alexandria, VA

Oracle DBA

• Installation using DBCA to create and DBUA to upgrade Oracle database and Oracle on UNIX, LINUX and WINDOWS servers
• Create databases, configuring them to meet developer and user requirements
• Use the range, list and hash partitioning keys to partitioning large tables
• Tune database to ensure acceptable level of performance and availability
• Install client side of Oracle on developers and end-users PC and configuring them with network connections
• Creating tables and views for developer and client needs
• Manages and maintains the data dictionaries
• Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN
• Monitors database activity and file usage, and ensures necessary resources are present so that databases function properly by removing or deleting old or obsolete files.
• Add/delete Oracle users, assigning correct roles and tablespaces

Confidential . Laurel, MD

Technical Support

• System configuration based on agency standard
• Interacted with customers via web based ticket system, phone and email communications in order to resolve product related issues
• Installation of PCs, Printer, Scanners and other PC peripherals
• Interfaced with customers to troubleshoot, analyze, reproduce, debug, and track technical problems.
• Makes recommendations to remedy errors and offers configuration guidelines to improve system performance
• Performed regular client preventive maintenance (PM) for all data traffic, storage and transmittal database files, accountable for database authenticity
• Escalated issues to Level 3 that require development of advanced debugging modules, compiled code or patch creation
• Work closely with other technical support specialists, testers, consultants, and R&D engineers.