We provide IT Staff Augmentation Services!

Oracle/ms Sql Server Administrator Resume

0/5 (Submit Your Rating)

SUMMARY:

  • IT professional wif global experience, including Oracle and MS SQL Server Database Administration in Windows and UNIX environments wif High Availability architecture.
  • 7 years hands - on experience in Oracle and MS SQL Server databases and 8 years of experience in Oracle E-Business Suite administration and its modules.
  • Expertise in installation, support, monitoring, and administration of Oracle database, MS SQL Server, Oracle Enterprise Manager OEM and Disaster Recovery Strategies.
  • Proficient in designing security policies for database and web-based applications.
  • Excellent analytical, research, trouble shooting, problem solving, communication and leadership skills.
  • Works well on a team and independently, skilled Confidential multi-tasking and prioritizing.
  • Hands-on experience on Agile Project Management using Scrum and Kanban framework.

TECHNICAL SKILLS:

  • Oracle Database 11g RAC/10g/9i/8i/7.3x
  • ASM
  • RMAN Backup and Recovery
  • Data Guard
  • OEM
  • Cloud Control 12c
  • Grid Control 1g
  • Data modeling
  • SQL Loader
  • EXADATA; Microsoft Azure Cloud Computing
  • MS SQL Server 2008 R2 2012 and 2014
  • Apache
  • Tomcat
  • Oracle WebLogic
  • JBOSS
  • Siteminder 12.0
  • Sun Solaris; REDHAT 6.0;
  • Windows 2003/2000;
  • Windows Active Directory; LDAP 11.7.0.0.1
  • Oracle WebLogic
  • PUPPET 3.0
  • Jenkins
  • Atlassian Suite ( JIRA 6.3.8 Confluence 5.8.13 )
  • ; Oracle EBS 11i E-Business Suites;
  • Oracle Directory Server 11.5.0; TOAD
  • FLUX
  • SPLUNK 6.2.3
  • Tripwire 8.3
  • TortoiseCVS 2
  • 5.03
  • Clarify
  • Rational ClearCase Attache
  • BSCS 5.01
  • COBOL
  • PRO*C
  • C

PROFESSIONAL EXPERIENCE:

Confidential

Oracle/MS SQL Server Administrator

Responsibilities:

  • Supported various Oracle and MS SQL Server Versions in teh organization.
  • Installed and maintained Oracle 11g RAC, and also installed Oracle Enterprise Manager 12c for database monitoring and performance tuning to support customer facing web-applications.
  • Scripted SQL, PL/SQL and UNIX Shell to ease DBA activities.
  • Built high availability standby database to handle DR scenarios for application and database stability.
  • Installed, configured MS SQL Server databases wif peer-to-peer and transactional replication, and database mirroring to handle application failovers.
  • Implemented various 12c agents and configured teh system to monitor databases, to alert DBAs critical issues for immediate resolution.
  • Developed and scheduled several Cloud Control jobs to perform database administrative tasks.
  • Scrambled Production data to use in non-prod environments.
  • Mentored DevOps team to write PUPPET code to automate server builds to minimize teh build time.
  • Applied database security patches and upgraded on regular basis to avoid security vulnerabilities.
  • Configured tripwire to monitor databases for logging and monitoring compliance for FFIC auditing.
  • Participated in audit review and documentation.
  • Implemented oracle security best practices.
  • Populated all user store from LDAP Oracle Directory Server (Sun Directory Server) into Oracle database to identify unauthorized users to security for auditing.
  • Fed data to Splunk log monitoring system to generate alerts and reports to operations team.
  • Played Project Manager Role in a database migration project, and active practitioner of Agile project management.
  • Involved in Sprint planning, Daily Stand-up, Sprint demo and Sprint retrospective while implementing features.

Confidential

Application and Database Engineer

Responsibilities:

  • Migrated Oracle Financials from 10.7 SC to 11i and integrated various non ERP systems as part of teh team.
  • Made 50% cost savings to teh organization by converting OPITO reports into Oracle Reports.
  • Implemented Accounts Receivable EIPP solution to provide paperless solution for quick cash flow.
  • Designed database to print customer invoice and billing statements.
  • Developed Apps extensions to fulfill teh business needs, and supported core EBS service modules such as OM, AR, PO and FA.
  • Contacted and coordinated wif oracle support to apply patches to resolve software bugs.
  • Provided solution to day to day application issues and assisted QA team for smooth deployment.

Confidential

Telecom Billing Consultant

Responsibilities:

  • BSCS Billing, Rating and Production Support.
  • Supported teh corporate accounts payment processing system using Lockbox system.

We'd love your feedback!