Experienced Software Engineer with 9 years of expertise in Linux Shell Scripting, Python scripting, Data Surgery, OnCall support, Handling ticketing tools, Enhancing performance, Production/Application support, and Oracle Database Administration activities. Regarded for capacity to streamline production processes and operations leading to cost savings and increased productivity. Proven record in troubleshooting, debugging, and support of complex systems. Experienced in automating critical Oracle processes in Unix servers/Windows servers using Python/Shell scripts. Adding good communication skills with Team Management and leadership qualities.
• Leading a team of 4.
• Data debugging, Data surgery (Looking for data discrepancy issues), Backtracking and analyzing data sources.
• Managing client meetings daily and coordinating with team to meet client's requirements within defined SLA.
• 24*7 On-call production support.
• Hands-on experience using ticketing tools like JIRA, Service Now, Orchard Now, etc
• Stay organized and be able to answer client questions about project milestones.
• Responsible for monitoring and fixing all ETL job failures.
• Automation of ETL process and adding some additional functionality to enhance performance.
• Provide SQL tuning recommendations based on Audit results.
• Developed shell scripts to support automated process from instance build to application deployments, produced SQL scripts and automated build pipelines for continuous deployment and testing, and provided Oracle and Linux support with 24/7 on-call rotation.
• Established multiple automation processes to support business requirements, enabled proper version control of all scripts, and successfully implemented a rolling deployment process.
• Automating DevOps tasks like Build scripts propagation, SVN hooks,
• Single click build and deployment, post-deployment validations.
• Handling PRODCUTION Database instances.
• Basic hands-on developing and modification of triggers, functions, stored procedures and packages, and PL/SQL procedures.
• Experience in Installation, Maintenance, and Administration in Production and Non-Prod databases on different flavors of Unix.
• Providing Production and operational support including Pro-Active database monitoring, Issue resolution, and on-call duties.
• Troubleshooting database and Query level performance issues by analyzing AWR, ADDM, ASH, Explain plan, and SQL Tuning Advisory.
• Building databases. Scheduling monitoring & backups. The transition of new databases & validating database before going to support.
• Following change process, escalation matrix, filling RCA, IRS audit and ready to learn any technology on project requirements
• Implemented automation solutions to simplify management process by controlling data replication, fixing inconsistencies and eliminating manual tasks, reducing lead time by 16%.
• Installing application schemas which include all application database objects (e.g. stored procedures, tables and indices) as required to address production incidents
• Managing database & resolving application issues as required for the resolution of an Incident.
• Implementing database tuning changes in response to incident, to restore DB performance, operating levels prior to incident by DB parameter modifications or Index level.
• Monitoring and responding to database related events as part of overall Preventive maintenance Services.
• Supporting regular database maintenance activities and Providing DBA support and consultation to multiple projects
LINUX