| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPh: PHONE NUMBER AVAILABLESummary Experienced Database Administrator with over 6 years of experience managing and maintaining complex database systems. Extensive experience in database administration, maintenance, and optimization, with a focus on Oracle and SQL Server environments and NOSQL. Utilized RAIK (Redundant Array of Independent Kernels) technology to implement high- performance and fault-tolerant storage solutions, enhancing data availability and system reliability in multi-node cluster environments. Conducted regular database performance monitoring and tuning activities, analyzing SQL execution plans, optimizing query performance, and implementing indexing strategies to enhance overall system efficiency and response times. Proficient in database backup, recovery, and disaster recovery strategies Skilled in performance tuning and query optimization, using tools such as Oracle Enterprise Manager and SQL Server Management Studio Experienced in designing, implementing, and maintaining database solutions to support business needs Familiar with cloud database technologies, such as Amazon RDS and Azure SQL Database Proficient in scripting and automation using PowerShell, Python, and Bash Experienced in working with database-related technologies, such as ETL tools, reporting tools, and BI platforms Skilled in collaborating with cross-functional teams, including developers, system administrators, and business stakeholders Effective communication and documentation skills, with the ability to present complex technical information in a clear and concise manner. Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottleneck in the database environment. Excellent communication skills, co-ordinate and communicate with system administrator, network engineer, business data analysis and development team. Experience as On-Call production DBA support. Hands on training on performance tester using load runner and JMeter. TECHNICAL SKILLSDatabase Skills: Oracle 19c/12c/11g/10g/9i, Oracle GoldenGate, Physical Data Guard, RAC Hardware: Sun Sparc E series, HP 9000, IBM RS6000, Compaq, EMC, UCS blades Operating Systems: Sun Solaris, HP-UX, IBM-AIX, Red Hat Linux, Windows NT GUI: Developer 2000 (Forms 4.5, Reports 2.5), Developer 6i (Forms 6i, Reports 6i) Database Tools: OEM, RMAN, Data Pump, Export/Import, SQL Loader, OWB, OID, ASM, Oracle RAC, Data Guard, Toad, SQL Developer, DPAMiscellaneous Tools: BMC Patrol, Veritas Clusters, Veritas NetBackup, Tivoli Data Protection, Cron Languages: SQL*Plus, PL/SQL, Unix Shell Scripting (csh, ksh, bash) Additional Skills: NoSQL, RAIK (Redundant Array of Independent Kernels) PROFESSIONAL EXPERIENCELiberty Mutual Finance Mar 2020 - CurrentOracle Database AdministratorResponsibilities: Provided 24/7 Oracle production database support for Oracle 10g/11g/12c/19c RAC and standalone databases. Implemented NoSQL database solutions (e.g., MongoDB, Cassandra) to support the storage and retrieval of unstructured data, improving scalability and performance for specific use cases. Configured and fine-tuned RAIK (Redundant Array of Independent Kernels) for efficient load balancing and fault tolerance, optimizing resource utilization and ensuring high availability in distributed computing environments. Managed and administered database systems as a DBA, including database installation, configuration, backup and recovery, performance tuning, and security management, ensuring optimal system operation and data integrity. Performed database design assessments with technical Product Owners to build and deploy standardized database solutions that meet business needs. Installed, configured, and maintained Oracle RAC and standalone databases. Installed and configured OEM Grid control. Installed and configured Oracle GoldenGate unidirectional and bidirectional replication. Upgraded GoldenGate from 12c to 19c. Managed, troubleshooted, and resolved Oracle database, RAC, and application issues. Involved in upgrade/migration of the Oracle database from 11g to 12c, 12c to 19c. Implemented high availability solution with Oracle 12c, 19c RAC, physical and logical standby, and replication using GoldenGate. Developed back-end logic for business applications, e.g., views, procedures, functions, triggers. Monitored/managed several RAC and standalone databases using OEM Grid control. Configured database backup using RMAN catalog database for full, incremental, and archive log backup.Ameri Source INC Mar 2017 Feb 2020Oracle Database AdministratorResponsibilities: Created and set up Dev/TEST/QA environments from Production database. Upgraded and configured Oracle databases from 11g to 12c. Collaborated with cross-functional teams to optimize database performance and troubleshoot performance issues, utilizing advanced tuning techniques and tools such as Oracle Enterprise Manager and SQL tuning advisors. Implemented high availability and disaster recovery solutions, including database replication, failover mechanisms, and backup strategies, ensuring data availability and minimizing downtime in case of system failures. Installed, set up, and configured Data Guard. Cloned databases using scripts as well as RMAN. Wrote shell scripts for alerts for ORA errors, backup and recovery, import and export procedures. Managed user security, privileges, roles, auditing, profiling, and authentication. Extensively tuned database performance, including SGA tuning. Created and managed database objects, including tables, tablespaces, data objects, indexes, user logins, and passwords. Refreshed and replicated databases from production to testing using hot backup. Partitioned tables and created index-organized tables and locally managed tablespaces. Worked with blobs, clobs, materialized views, and bitmap indexes. Managed storage, including space, tablespaces, segments, extents, rollback segments, and the data dictionary. Installed and administered Automatic Storage Management (ASM). Involved in database designing and database architecture. Evaluated and researched hardware for Oracle RAC environment. Used Oracle Advanced Replication feature to set up multi-master replication. Conducted business impact analysis, developed recovery strategy, and planned testing and training for business continuity and disaster recovery plans. Education: BACHELOR OF SCIENCE WITH HONORS IN BUSINESS AND INFORMATION TECHNOLOGY Certification: OCA DIPLOMA IN BANKING AND FINANCE CERTIFICATE IN BUSINESS STUDIES HIGH SCHOOL DIPLOMA |
