- Operating Systems
- HP-UX 11.x. Sun Solaris 8, 9, 10. AIX 5.x, 6.x, Linux Enterprise Server 9, 10. Windows 2010, 2012
- RDBMS
- Oracle 19c, 12c, 11g, 10g, MySQL, PostgreSQL from 9.6.x to 12.x, Oracle 10g, AWS solution Architect.
- Languages
- SQL, PL/SQL, UNIX Shell Scripting.
- Software/Applications/Tools
- TKPROF, EXPLAIN PLAN, AWR, and ADDM.
- Toad, RMAN, Putty, NX client, WinSCP, Remote Desktop Connection, VNC, Jira, SQL Developer, SQL Server and Cisco VPN Client, BART, PEM, pgbadger, Nagios
- Database Utilities
- SQL
- Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL
- Loader, RMAN, DataPump, Export, Import, psql, pg_dump, pg_basebackup, pg_upgrade
- Key Skills
- Configuring PostgreSQL Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios.
- Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
- Responsible for backup, recovery, and upgrading of PostgreSQL databases.
- Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
- Extensive experience with Cloning and Refreshing pre-prod/dev databases with prod databases.Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL
- PLUS, AWS Console, SQL Server, TOAD etc.
- Enforced Security Administration, system monitoring by adding and removing users, auditing, and analyzing security problems.
- Wrote scripts to inform DBAs regarding the status, performance, and space management of the database.
- Experience in Linux (RHEL 5.0, 6.0), Oracle Enterprise Linux 6.5, Centos.
- Installation, configuration, and Hardening of standalone Linux servers.
- Proficiency in Linux Command Line and Operating System.
- Configuration and management of network services (HTTP, NFS, SCP NTP).
- Experience in Performance Tuning (I/O, Memory & SQL Tuning) by using tools/utilities like Automatic Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Autotrace, TKPROF and Statspack.
|
- Experience in maintaining Oracle Data Guard and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
- Good knowledge in Hot/Cold Backup, Recovery, and Cloning of databases using RMAN.
- Installed and Configured the Oracle Databases (10g/11g) RDBMS, Performing Pre-installation, and Post-Installation Tasks
- Expertise in Installing and configuring ASM and RAC for high availability databases.
- Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
- Strong troubleshooting, problem solving, analytical and design skills.
- Experience in cloning Database from Production to Test and Development and from Development to Production.
- Experience in cloud computing (AWS & IBM Cloud).
- Good knowledge in Agile Methodology & DevOps Culture.
- Have comprehensive knowledge and experience in Creating, Installing, Managing, Upgrading, Patching Oracle RDBMS, Cloning, Backup and Recovery Strategies, Managing Security, Users, Disk Space, Oracle File System Management, Task Scheduling, Oracle DATAGUARD, Performance Monitoring and Tuning, Real Application Clusters (RAC) and Oracle Flashback Technology and documentation.
- Extensive knowledge on database administration for Oracle 10g, 11g and 12c, 19c with experience within very large-scale database environment and mission critical large OLTP and OLAP systems.
- Excellent experience in installation, setup, and configuration of Oracle 10g and 11g in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
- Hands on experience in configuring, managing, troubleshooting, and migrating single instance databases to multimode 10g, 11g R1, R2 and 12c, 19c RAC environments on various flavors of UNIX systems for high availability and load balancing.
- Data loading using SQL
- LOADER, Logical backups using full export and DATAPUMP.
- Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL
- LOADER.
- Participated in planning and implementation of off-site Disaster-Recovery planning and testing
- Worked with development and operations staff in resolving problems quickly and efficiently
- Configured and maintained Physical, Logical, Snapshot standby databases supported by Data guard on Oracle 11g, 10g RAC servers for disaster recovery procedures
- Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user tablespace across Oracle databases.
- Good experience in applying Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run installer, also involved in Upgrading and Migration of an Oracle server to higher version available.
- Proficient in Zero Downtime Migration to Oracle Exadata Using Oracle Golden Gate.
- Experienced in capacity planning and estimating the growth of Oracle databases
- Good exposure in Configuring Single instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM), ZFS Storage, Exadata and Golden Gate
- Expertise in installing, configuring, and maintaining Standalone and RAC databases.
- Administrative, Agile, AIX 5.x, IBM AIX, Application Development, Architect, ASM, Auditing, Automate, Automation, Backup, Bash, Bi, Business solutions, C, Capacity planning, Catalog, Cisco, Interpersonal, Consulting, CPU, Encryption, Clients, Client, Customer service, Data migration, Data Modeling, Data warehouse, Database administration, Database, Databases 9.6, Databases I, Databases, Database design, DBMS, Data warehousing, DC, Debugging, Designing, Disaster-Recovery planning, Disaster recovery planning, Disaster Recovery, Documentation, Estimating, Features, Flash, Functional, HP-UX, HTTP, IBM, DB2, Indexing, Linux 6.5, Linux, Managing, Materials, Meetings, Memory, Mentoring, Windows, Migration, Modeling, MySQL, Enterprise, Network, NFS, OLAP, OS, Operating Systems, Operating System, Optimization, Oracle, DBA, DB, Oracle DBA, Developer, Oracle Enterprise Manager, PL/SQL, Peak, Perl, Pl, Postgres, PostgreSQL 9.6, PostgreSQL, Problem solving, Problem-solving skills, Python, Quality, Quality control, QA, RDBMS, Oracle RDBMS, Real-time, Real Time, SAP, Scheduling, SDLC, Servers, Shell scripting, Scripts, Shell scripts, Shipping, Simulation, SLA, Service level agreement, SMS, Sun Solaris, Sun Solaris 8, SQL, SQL Server, SSL, Statistics, Strategy, Strategic, Strategic Planning, Tables, TOAD, T-SQL, Troubleshoot, Troubleshooting, UNIX, UNIX Scripting, UNIX Shell Scripting, Upgrades, Upgrade, Upgrading, Utilities, VPN
|