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.