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
Development Tools
Others
Software Engineering
Database
Operating System
Data & Analytics
Web Development
Networking & Security
Graphic Design
Programming Language
Positions
Portfolio Projects
Company
MIS Autimation
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.
IBM Tririga/Database Installation, configuration, Management and support
https://www.jll.co.inSupervised end-to-end technical project management
Company
IBM Tririga/Database Installation, configuration, Management and support
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
Company
Application Life Cycle Management (ALM)
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)
Company
Risco Access Conrol
Role
Backend Developer
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)