SUMMARY:

• Highly Skilled IT Consultant/Oracle DBA/Architect/SysAdmin with a strong background in implementing Highly Available Systems infrastructure and supporting 24x7 mission critical large - scale systems.
• Oracle Database 11g Certified Professional (OCP) with 11 years plus of aggregate IT experience covering areas, including: High availability, Disaster Recovery, Encryption, Data Warehousing, Upgrades,
• Security, Development, Implementation and Maintenance, migrations, performance tuning, Administration and backup/recovery on Redhat Linux, UNIX, Oracle Enterprise Linux/Sun Solaris/AIX/Windows servers.
• Expertise in administration of Production, Test, Staging, PROD Fix, Break/Fix, Dev using Oracle 10g, 11g, 11i, 12c, RAC, 9i, 8i, MySQL, PostgreSQL, and Microsoft SQL servers
• Installing & configuring 11.2.0.3 RAC database on RHEL 6.3
• Upgrading both standalone and RAC databases from 10.2.0.4, 11.2.0.2. To 12c.
• Implemented database auditing, data security and Remediate high-risk violation in production environment.
• Applying one off patches using OPATCH utility.
• Expertise in managing and configuring mission critical IT Systems in standalone/virtualized environments
• Experience in database architect, design with both logical and physical, data modeling, creating and managing entity relationship map using Visio Flow Charting, Erwin and other ER Diagram Tools
• Agile & Scrum Methodology with proficiency in Software Development Life Cycle (SDLC)
• Understanding of ITIL methodologies, framework and application to support IT service management
• Excellent written, presentational and verbal communication skills
• US Citizen and Authorized to work in the US for any employer

TECHNICAL SKILLS:

Databases­: Oracle 10g/11g Oracle Tools­ DBCA, Oracle Enterprise Manager (OEM), SQL*Plus, Recovery Manager (RMAN)

SQL: Loader, Data Pump, AWR, Data Guard, RAC, ASM, Oracle Enterprise Manager Grid Control, DBCA, Netca, Netmgrand others. UNIX (Linux & Solaris), Windows (95, XP, 2000, 2003, Vista). Application Servers (HTTP Servers) ­

Apache/Tomcat: MySQL Server, Internet Protocols ­ HTTP/S, FTP, SMTP, Secure Shell (SSH), XHTML, HTML, PythonXPATH, PostgreSQL, SQL, XML, XSLT, PHP, Java, PL/SQL programming, PLSQL Developer, Eclipse, Cascading Style SheetsCSS, CSS3, HTML5, Responsive Design Patterns, JavaScript and JQuery. CMS Content Management Systems (WordpressSharePoint & Drupal) and Microsoft Visual Studio 2010, Lamp stack, Agile & Scrum Methodology

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA

Confidential, Bethesda, MD

Responsibilities:

• Part of a five enterprise Technical team managing Data warehouse with 50 plus Terabytes of data.
• Work closely with business and technical teams to articulate business needs and system capacities.
• Responsible for Planning, installation, configuration, management of Oracle 10g, 11g and 12c databases in a production, Dev and Test environments on Linux, Unix, and Windows servers.
• Installed and configured 12c databases. Configured Kickstart files, installed RPMs, and Packages.
• Worked with Unix/Linux bash scripting to automate database tasks and do OS level backup of databases.
• Provides database best practice on design methodologies and continuously re­assess the infrastructure for opportunities to optimize performance or reduce costs.
• Work with application teams on all aspects of database design including tables, views, stored procedures, packages and manage role based grants.
• Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions without engineering changes.
• Worked on and wrote in Oracle SQL, PL/SQL, SQL*Loader, Query performance tuning, created DDL scripts, created database objects like Tables, Views Indexes, Synonyms, Sequences and Materialized view for distributed data migration.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Worked on 12c cloud control administration
• Implemented database backup/restore strategies using RMAN and Linux bash scripts.
• Handled all interactions with various teams as a Subject Matter Expert during design, implementation and integration testing phases
• Maintain and enhance the Confidential data ETL process and flow, Query Optimization, PL/SQL Stored
• Procedures and triggers. Wrote and implemented UNIX Shell scripting and korn shell scripting.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Developed mappings, sessions, workflows monitoring in Informatica Powercenter 9.x.
• Conducting data analysis reviews of deliverables and database architecture designs. Creating and managing Entity Relationship Diagrams and logical data model using Erwin/Visio.
• Utilize a variety of tools ­ OEM, RMAN, Data Guard, Data Pump, UNIX shell scripts ­ to backup, refresh/clone databases
• Leverage AWR/ASH/ADDM/ reports and OEM (SQL Monitoring and Tuning Advisor) to monitor and optimize poor performing reports
• Worked and supported applications running on MicroStrategy Cluster, Serena Dimensions CM, and Oracle SOA for Middleware, Data Marts, Data Warehouse, Oracle WebLogic, IBM Sys Architect, Oracle OIM and SOA, Oracle Unified Directory (OUD), Oracle Virtual Directory, Informatica and Oracle ADF Server.
• Implemented data replication between database systems using materialized views from different systems

Environment: Oracle 11g RAC, EM Grid Control 10/11g, RMAN, Oracle 12c, 11g, 10g on UNIX (Solaris, AIX, Linux) and Windows

Confidential, S ilver Spring, MD

Responsibilities:

• Installation of RHEL 5.4, 6.4, 7.2, CentOS 7.2, Oracle Linux 6.4 in virtualized environment.
• Perform routine administrative and maintenance functions (install, configure, patch, update, etc.) server platforms. Install and manage packages using RPM and YUM packages
• Support Oracle databases, MS SQL Servers, MySQL, Apache and Enterprise content management systems.
• Worked shell scripts such as bash, awk and sed
• Created Bash Shell scripts to monitor system resources and system maintenance and Performed administrative tasks such as System startup/shutdown, and backup strategy, error detection and scheduled cron for job automation.
• Provide improvement of the security, usability, performance, maintainability, and scalability of the existing environment
• Manages systems routine backup, scheduling jobs and enabling cron jobs.
• Create, Manage Virtual Machines for Oracle Databases using templates, snapshot and cloning.
• Improve system performance by working with the development team to analyze, identify and resolve issues quickly and perform server administration tasks such as user account management and access control.
• Maintain documentation of necessary installation procedures, instructions, and other documentation required by clients.

Confidential

IT Consultant ­ Lead Oracle DBA, Bethesda, MD

Responsibilities:

• Responsible for Planning, installation, configuration, management of 50 plus Oracle 10g, 11g and 12c databases in a production, development and test environments on Linux, Unix, and Windows servers.
• Work with enterprise, BAs, B2Ts and application team to ensure high availability of the database for application testing and data availability:
• Develop, implement and maintain change control and testing processes for modifications to databases.
• Led efforts that provided collaboration reports to Confidential, client leadership, and project teams, this effort contributed to the reduction of travel expense for some of the clients.
• Administered and maintained the Client’s databases including daily monitoring and performance analysis using, ADDM, Gathered and analyzed AWR report
• Mentor and cross train team members in development and architecture methodologies to increase project throughput.
• Created shell scripts to automated backup for Cold and Hot backups
• Created cron script for nightly incremental physical database backup to disk.
• Create stored procedures for data extraction purposes.
• Implement data quality and data quality metrics solutions for financial data based Operational data sources
• Performed database tuning by generating Explain plan for long running SQL queries, created indexes on columns to improve performance
• Implemented backup and recovery strategy for disaster recovery using Hot/Cold Backups Oracle backup utility such as RMAN
• Wrote stored procedures, Unix/Linux scripting, bash scripting, updated cron script and SQL queries for data extraction from SQL Server

Confidential

Oracle DBA, Bethesda, MD

Responsibilities:

• Responsible for Planning, installation, configuration, management and troubleshooting of 15 (50G to 1TB) Oracle 10g & 11g databases in a production, Dev and test environments on Linux and Unix servers..
• Managed all aspect of databases and ensure that they smoothly.
• Active member of the Production 24/7 on call support team that supports all related Databases Worked on system supporting projects for USAID, DEFID AUAID, DOD and DOJ in 150 plus countries.
• Advised Data Architects and Developers on best practices in relation to data models, Data Definition Language /Data Manipulation Language, and suggest areas of improvement for performance and efficiencies. Develop tables, indexes, stored procedures, views, triggers and other objects.
• Extensive use of Structured Query Language (SQL), Data Definition Language (DDL), and Data Manipulation Language (DML) to check the data transaction and integrity
• Implement database backup/restore strategies using RMAN and Linux bash scripts.
• Develop, implement and maintain change control and testing processes for modifications to databases.
• Administer database user accounts. Create, modify and deactivate user accounts Assign and monitor user access rights. Regularly monitored Alert log Files and trace files on day-to-day Basis.
• Used Data Pump for migration, Remapping, SQL*loader, import and export of database/schema/Tablespace.
• Implement database backup/restore strategies using RMAN and Linux bash scripts.

Confidential

Oracle Database Administrator, Glen Burnie, MD

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Independently and proactively serves as liaison with the Information Technology departments, staff, Development, business users as well as vendors to determine information requirements (both present and future) and drives the development of the infrastructure so those business needs can be met.
• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Managed all aspect of databases and ensure that they smoothly.
• Applied patches, keeping applications software bug free, and improving data integrity.
• Implemented backup and Recovery Strategy using RMAN
• Tuned the databases for optimal performance and monitoring CPU performance.
• Installed, configured and managed 11gR2 (RAC) cluster on ASM storage
• Responsible for Oracle logical and physical databases design, implementation and maintenance
• Upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set.

Confidential

Database Administrator and Linux/Unix Sys Admin, Ann Arbor, MI

Responsibilities:

• Managed Oracle/SQL/MySQL, RHEL 5.4, 6.4, Unix Oracle Linux, Virtualized servers administration.
• 7x24 monitoring and review of Production Database Application Server Components including alert logs, scheduled job status and wide variety of application server performance parameters
• Managed all aspect of databases and ensure that they smoothly.
• Database Server installation, configuration and set­up on RHEL and Linux servers
• Implement database backup/restore strategies using RMAN and Linux bash scripts.
• Monitored database security by controlling and monitoring user access
• Develop best practices based on associated security policies, industry security standards, and audit regulations to ensure devices are appropriately secured from security breaches Resolve compliance break fix incidents based on vulnerability testing, audits, and/or associated security monitoring systems
• 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 organization's operational requirements.

Confidential

Senior Web Developer, Baltimore, MD

Responsibilities:

• Designed, developed, and launched web based content management systems
• Collaborates and coordinates projects between software, design, management team
• Assists in the technical analysis and evaluation of new technologies, products, and product enhancements.
• Worked on projects for Bristol Myers Squibb, Valeant and Patheon

Confidential

Web Developer, Georgetown, DC

Responsibilities:

• Worked with a team of six developers. We developed custom software solutions for Real Estate sector
• Integrate third-party software applications within the existing application environment
• Developed and ensured User Experience and User Interface standards
• Implemented User interfaces with such tools as JavaScript, SQL, MySQL Server, PHP, HTML, CSS, XSLT and XML