SUMMARY:

• 9 years total IT experience in Oracle and other RDBMS & Windows Systems Administration, Design & Development, Systems Architecture and Infrastructure.
• Proficient in Installation, Troubleshoot, Maintenance and technical Support for Oracle (10g and 11g) Databases, Oracle RAC, Active Data Guard and OEM 11g
• Support database in a High Availability environments.
• Strong understanding and use of RMAN for backup and disaster recovery
• Results - driven DBA with skills in team building and problem-solving with an established reputation for effectively working with diverse groups of people and adaptability to changing environments and new software version releases.
• Experience with database backup, restore, and disaster recovery procedures
• Oracle Real Application Clusters (RAC) in development and Production environments.
• Experience as On-Call 24x7 production DBA support, system administrator; handle business service requests using Helpdesk Request Management.
• Experience in Active Data Guard (11g) setup and configuration.
• Strong knowledge of oracle data-dictionary, configuration of Oracle Enterprise Manager (Oracle Grid Control) tools for monitoring, performance enhancement and debugging
• Knowledge in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN)

TECHNICAL SKILLS:

Additional Skills: SharePoint 2010/2013, Postgres and MySQL administration.

Hardware/Software: SQL Server 2000/2005/2008/2012, ORACLE 11g/10g/9i SQL*PLUS, SQL*Loader, Developer 2000/6i,, SQL, PL/SQL, UNIX, Linux, Windows 2K3,Win 2k8,SQL Navigator, TOAD, ERWIN, DBArtisan, Data Guard, Oracle Grid Control, PLSQL, OEM,SunOS 5.8/10, UNIX 4.0, AIX, Windows 2003/ XP/NT, Unix Shell scripting, XML, HTML, Java, Visual Basic, MATLAB, VB Script, and MS office.

PROFESSIONAL EXPERIENCE:

Confidential,MD

Senior Oracle and SQL Server Database Consultant

Responsibilities:

• Provides Oracle and SQL Server database design, architectural and infrastructure solutions to Confidential for Bioinformatics.
• Installed and Configured Oracle 10g/11g software on Linux.
• Maintain Relational Database infrastructure, software, upgrades, and patches.
• Monitor and provide response for all database systems.
• Use RMAN duplicate command to clone/refresh development database from production.
• Upgraded several databases from Oracle 10.2.0.5 to 11gR2.
• Participating in monthly systems and database maintenance window during the weekend.
• Develop and document disaster recovery procedures, in accordance with Confidential and Confidential policies.
• Use RMAN to perform database recoveries and migration when necessary.
• Used Oracle flashback technology to restore databases and tables as needed.
• Setup technical procedures and administrative policies for Production, Test, QA and Dev database physical design, administration, maintenance, performance tuning, backup and recovery.
• Refreshing databases and/or schemas with new data when needed.
• Design and implementing database security strategies for user and application access levels.
• Design database structures, auditing, security, managing patches, and other tasks as needed to ensure regulatory compliance and a proactive security posture.
• Use Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII data.
• Provide technical assistance to application developers and end-users.
• Conduct research relating to Oracle, SQL Server and other RDBMS open source database.
• Perform disaster recovery testing on a quarterly basis to ensure data integrity, confidentiality, and availability.
• Installing and configuring MS SQL Server 2005\2008 fail-over Cluster and its applicable Service Packs.
• Setup, configure, administer and maintained SQL Server databases (Prod, Stage, Test and Dev Environment) for various groups such as Developers, QA and DA users and ensured database availability in a 24X7 environment.
• Implement MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node
• Upgrade SQL Server database environment from SQL Server 2000 -> 2005-> 2008->2012
• Scheduling and managing SQL Server database backup jobs.
• Monitoring Oracle and SQL Server jobs performance and impact on normal operations.
• Managed and maintain MS SQL Server in a Production on an 8 node failed-over cluster environment.
• Conducted root cause and analysis for database incidents and problems.
• Developing and implementing DBA maintenance plan
• Participated in meetings impacting databases physical architectural design.
• Managing database object permissions, user accounts and passwords.
• Deployed SSIS projects. Schemas and configured Report Server to generate reports through SSRS.
• Assist web Application developers with database related issues
• Assist and support MySQL and Postgres database related issue

Confidential,Reston,VA

Oracle Database Consultant

Responsibilities:

• Provided database design, technical and infrastructure solutions to Transportation Security Administration (TSA-ITIP).
• Designed, configured, deployed and maintained active physical Data Guard 11g (Active/Passive) on more than 20 instances in Production environment.
• Implemented ASM cluster on Oracle RAC 10g (Active/Active & Active/Passive) on 4 node cluster.
• Maintains Oracle Application Server 10g with Oracle E-Business Suite Release 11i.
• Support and managed databases in High Availability environments.
• Migration of several databases (size 500GB -3.2TB) and Applications to new servers using RMAN.
• Evaluates new releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate.
• J2EE application support and support
• Define Database Backup, Recovery and Disaster Recovery procedures using RMAN, flashback.

Confidential,Mclean,VA

DBA/Systems Engineer

Responsibilities:

• Part of a team that was responsible for controlling and maintaining the company information system databases.
• Responsibilities were to perform daily, weekly, and monthly checks of all databases.
• Ensure that daily backup using the export utility and monitoring the CRON jobs to ensure backups are good for restore and recovery.
• Provided first level support for helpdesk work tickets and manage all calls logged regarding the databases.
• Installed and Upgraded Oracle 9.2.x to 10G (10.2.0.2) on new LINUX Red Hat Servers.
• Assisted Sr. DBAs to develop capacity and performance metrics as well as maintain, analyze, and report on a scheduled periodic basis to management on development progress.
• Created Oracle instances with appropriate initialization parameters.
• Primary on call support duties for a week every month, which include monitoring mission-critical servers.
• Deploy software and security patches using Windows Update Server
• Configured and support MS SQL Server 2000/2005 databases in a clustered environments.
• Installing, configuring, and maintaining all database servers, working with network engineers in moving servers behind the firewall, and configuring tnsnames files to access databases behind the firewall .
• Documented database creation and migration process.
• Applied Oracle upgrades and CPU patches.

Confidential,Ellicott City,MD

IT Consultant

Responsibilities:

• Install, configure, and manage Oracle databases 9i/10g on UNIX, Linux and Windows platforms, manage and support Oracle and MS SQL server databases of various sizes
• Partitioning tables to improve performance and manageability
• Monitor database instances to ensure availability, ensure uptime
• Create and modify database structures as required by developers due to business or application requirements, creating test databases for testing and training
• Analyze and administer database security. Control and monitor user access to database. Audit database usage when necessary
• Monitor backup procedures. Provide recovery when needed. Develop and test backup and recovery procedures
• Major Oracle database migration from old servers to new servers
• Also meet with clients to discuss new improvements and update on overall security measures