Senior Database Administrator
EastNets
Total years of experience :18 years, 3 Months
• Responsible for management of Oracle 11g RAC databases on various UNIX flavors from the command line as well as web-based database control.
• Use Oracle ASM and Solaris QFS as storage file systems for RAC databases.
• Perform single instance and RAC database backups through RMAN and Data Pump.
• Perform database performance tuning, object defragmentation and capacity planning.
• Perform RAC node addition and deletion.
• Configured and resolved issues with Oracle Data guard.
• Perform switchover and switchback of databases.
• Apply critical patch updates (CPU) on the Oracle databases.
• Use database utilities like sql loader, log miner and dbverify.
• Develop scripts to extract the data required for migration from Oracle to MSSQL Database.
• Implement and manage Microsoft SQL Server 2008 Database.
• Perform data replication to DR site through log shipping and mirroring in SQL Server 2008.
• Perform database user management.
• Involved in security hardening of Oracle Database and UNIX operating systems.
• Provide technical support for internal users and resolved trouble shooting tickets
• Responsible for installation and administration of Windows 2003, 2008 and RHEL, Debian, AIX & Solaris servers.
• Design and implement Backup and recovery solutions for servers, databases and applications.
• Implement SSL certificates, sftp and housekeeping shell scripts.
• Perform day to day server maintenance tasks, monitoring and resource utilization.
• Enabled and used protocols/services such as ssh, ftp, sftp, snmp smtp etc on a regular basis.
• Upgrade Tomcat and Apache web servers.
• Install, configure and administer VMware ESXi servers and vCenter.
• Install and configure the vSphere ESXi hosts, storage, network and vCenter servers.
• Managed and maintained guest production and test virtual machines running on ESXi hosts.
• Create and manage Amazon EC2 instances and its images.
• Configure and administer monitoring tools like Nagios and OpManager.
• Configured Backup Exec 2012 and administer tape library.
• Applies & manages level one application support, testing, evaluation, software deployments, upgrades and bug fixes.
• Monitor and ensure agreed levels of services (SLA) are met.
• Implemented ITIL Framework to streamline the IT processes and procedures in the company.
• Perform changes on the production environment following the Change Management procedure i.e. after sufficient consideration, testing, and approval have been given to changes.
• Provide weekly service availability and disk space reports to the clients and service bureau management and other reports like Operations guide and checklist.
• Communicate and coordinate regularly with Network, Platform support and Application development teams for various requests from the client.
• Monitoring and maintaining two 24/7 production 400 GB databases under RHEL4ES and Windows 2003 server having more than 800 users.
• Designed and Implemented Oracle Disaster recovery solutions.
• Configured and Managed both physical and logical standby databases for the production databases
• Tuning SQL statements and I/O in Batch jobs and monitoring them.
• Tuned database performance by running custom scripts against the database and using STATSPACK, AWR and ADDM packages.
• Tuning the different kinds of wait events.
• Migrated and upgraded the 9i 32-bit database from middle end servers to Oracle 10g 64-bit on IBM Blade servers.
• Performed Data guard Switchover and Switchback.
• Restructured and improved application queries and memory structures to achieve 20% overall performance increase.
• Setup Oracle replication of data from Production to Test Databases.
• Create PLSQL objects like Triggers, Functions, Procedures, Cursors and Sequences for various Applications.
• Applying latest patches on both primary and standby databases.
• Scheduled both physical and logical backups and monitoring their logs to ensure their successful completion.
• Created test database for developers and helping them for designing logical objects.
• Responsible for Implementing Backup and recovery strategies like RMAN and Exp/Imp.
• Detect Block corruption and repair the objects using RMAN Block Recovery, DBMS_REPAIR or recreate them.
• Partitioned huge tables and indexes to improve query performances and rebuild the tables to eliminate fragmentations.
• Perform Flashback of tables and Database.
• Cloned Database using RMAN and Cold Cloning methods.
• Complete management of the Red Hat Linux including mounting disk partitions.
• Responsible for security of users and databases.
• Took decisions in Capacity planning.
• Configure tools like Database Control to administer the Databases.
• Dealt with various issues like Invalid objects and ORA errors.
• Good knowledge of installing and administering Oracle 11g Database.
• Use SQL Loader to upload any flat files into the Database.
• Monitor the size of all the Databases and develop scripts to monitor for various tasks.
• Develop shell scripts and scheduled jobs using Oracle 10g Scheduler and O/S utilities like Crontab.
• Resolve various SQL*NET issues.
• Upgraded 9i single instance Database to Oracle 10g RAC Database for Production environments.
• Perform Node addition and deletion in RAC.
• Ensure the availability of all the nodes in the Cluster.
• Manage the workload across the Instances.
• Complete services, user management and security.
• Manage growth of Tablespaces and Backup disk space.
• Perform Tape backups.
• Determine chained rows in tables and rebuild them.
• Tune SQL Statements and memory structures to enhance the improve query response time.
• Perform Capacity planning.
• Regularly take cold backups, logical and RMAN backups.
• Use Flashback and Exp/imp to recover tables and also used Log miner.
• Recovered Data file losses on Production Database.
• Monitor alert log and trace files.
• Applied patches like Critical Patch Upgrades.
• Create private and public Database links between different servers.
• Manage complete listener security.
• Perform data loads using SQL Loader.
• Cloned Oracle RAC Production Database to Test Environments using RMAN.