Now you can Instantly Chat with Raju!
About Me
- Experience with Oracle 12c/11g/10g/9i on UNIX, LINUX RHEL systems supporting Production Database of size ranges more than 100 GB.
- Exposure of project management activities which include planning, design, scope management, estimat...
- Experience in Oracle 12c/11g/10g/9i database installation & configuration and in applying PSU patches.
- Experience in RAC Implementation, maintenance of Clustered Databases, ASM implementation and maintenance.
- Experience in Designing Data Guard solution and Implementation, and in managing Physical Standby databases.
- Experience in backup and recovery using RMAN, flashback technology, user managed backup, exp/imp utility, data pump, creating standby databases using RMAN, refreshing test environments using production backup.
- Experience in monitoring and optimizing the Database Performances through Tuning using AWR, ADDM, Explain Plan, Toad. Tuning backup timings of databases.
- Experience in Database upgradation.
- Good exposure to Real Application Cluster.
- Experienced in complete range of Oracle DBA activities including day-to-day production database monitoring.
- Good experience on PL/SQL
- Good knowledge and understanding on MS SQL Server, DB2
- Good knowledge on AWS services like EC2, S3, IAM, ELB, VPC, Auto Scaling, EFS, Cloud Watch, Cloud Trail, SNS, RDS, Dynamo DB, Redshift. I would like to work on these services as well.
- Good knowledge on DevOps, tools are Docker, Chef, Ansible, Github
Skills
Positions
Portfolio Projects
Contribute
Ensured database management environments are updated with current stable versions of software products including monitoring, high-availability, backup/recovery, security, capacity planning.
Description
- Ensured database management environments are updated with current stable versions of software products including monitoring, high-availability, backup/recovery, security, capacity planning, tuning, performance enhancements
- Assist to project coordinator in project management from scoping, planning, SOW, effort, estimation, design, resource coordination and delivery as per specified timeframes
- Training to staff and define role & responsibilities of every MIS coordinator & others.
Contribute
Supervised end-to-end technical project management from scoping, planning, SOW, effort, estimation, design, resource coordination and database delivery as per specified time frames.
Description
- Ensured database support (24X7) & manage environments are updated with current stable versions of software products including monitoring, high-availability, HADR, backup/recovery, security, capacity planning, tuning, performance enhancements
- Worked for hosting, installation, and configuration and post-implementation maintenance of IBM TRIRIGA (9.x/10.x), BIRT/Crystal Reports, IBM TRIRIGA AutoCAD Integrator/Publisher version 10 & 12, RDBMS, GUI Tools, 3-Tier Architecture, Oracle 9i/10g/11g/12c, Microsoft SQL Server 2000/2005/2008 R2/2012, IBM DB2
Contribute
Sr. Database Administrator (Oracle & SQL Server)
Description
- Installation and Maintenance of primary and standby database with active Data Guard and Observer on Linux.
- Production databases (24x7) support, monitoring and maintenance.
- Database creation, patching, up-gradation and migration.
- Installation and configuring Oracle work flow
- Planning and developing the procedures for integration services.
- Design primary and standby database storage structures
- Maintaining and developing the database maintenance and backup scripts
- RMAN configuration and administration
- Backup strategies and recovery procedures using RMAN
- SQL Tuning Using TOAD and SQL Developer, Explain Plan, OEM and AWR.
- Database/Instance tuning
- Monitor and allocate storage space for databases
- Monitor and Controlling of user access to the database
- Oracle network management
- Planning for future database growth
- Replication of schema using Data pump or Export/Import to debug the production issue.
- Manage Databases (Dev, Testing, Production)
Contribute
Lead & managed project teams throughout the project lifecycle and provided support & guidance on technical and project-related issues.
Description
- Monitored project progress as per scheduled deadlines for various tasks and taken necessary steps to ensure completion within time, cost and effort parameters
- Developed the cost models to identify and decide on the cost-effective and best solution for customers
- Adhered to change management procedures and methodologies for executing software upgrades
- Managed Dvelopment, QA and prodction database.
- Database creation, patching, up-gradation and migration.
- Installation and configuring Oracle work flow SQL Server
- Planning and developing the procedures for integration services.
- Design primary and standby database storage structures
- Maintaining and developing the database maintenance and backup scripts
- RMAN configuration and administration
- Backup strategies and recovery procedures using RMAN
- SQL Tuning Using TOAD and SQL Developer, Explain Plan, OEM and AWR.
- Database/Instance tuning
- Monitor and allocate storage space for databases
- Monitor and Controlling of user access to the database
- Oracle network management
- Planning for future database growth
- Replication of schema using Data pump or Export/Import to debug the production issue.
- Manage Databases (Dev, Testing, Production)