Application Support Engineer / Devops
SmartConnectt Technology
Total des années d'expérience :9 years, 3 Mois
* Currently employed as an Application Support Engineer, specializing in tools such as Oracle SQL Databases. * Responsible for creating SQL queries to extract data from Oracle database according to client requirements. * Responsible for creating DML SQL queries to manipulate data in Oracle database according to client requirements. * Deploy SQL index in database to optimize application performance. * Actively involved in providing comprehensive support for database management and overseeing the deployment of patches. * Responsible for delivering production support for user journey applications, including monitoring performance, addressing reported issues, and ensuring adherence to SLA commitments. * Utilize the Dynatrace dashboard tool to monitor application performance, infrastructure, and network health, creating or adapting dashboards based on client requirements to track key performance indicators (KPIs). * Facilitate weekly 3-day client meetings to provide project updates and discuss ongoing developments. * Play a key role in supporting the development and testing of new software applications, ensuring a seamless transition to production. * Collaborate with the Infrastructure team to conduct Disaster Recovery (DR) drills during critical issues. * Undertake DevOps responsibilities, including maintaining all three application code versions on GitLab.
* Working as an SQL Support Engineer with technical tools such as SQL Databases (Oracle, SSMS, MySQL). * Work closely with the database team to provide support for database and patch deployment. * Responsible for creating DML SQL queries to manipulate data in Oracle database according to client requirements. * Responsible for providing production support for all banking loan management system applications, such as Mifin, Miles, EUC, and monitoring the application's performance on AppDynamics. Coordinate and follow up with the vendors to fix reported issues and problems and monitor the SLA. * Advise customers regarding the product's proper use and address specific user issues. * Troubleshoot application problems with good communication, coordinate with stakeholders and understand requirements. Set up DEV/QA/UAT environments and document requirement issues. * Facilitate weekly meetings with clients to provide project updates. * Perform daily monitoring of applications using AppDynamics tools. * Investigate and identify the root causes of customer issues and provide detailed reports to stakeholders. * Support the development and testing of new software applications, ensuring a smooth transition to production.
* Investigated and resolved customer issues by identifying root causes and providing detailed reports to stakeholders. * Established proactive monitoring systems to detect and address system issues before customer impact. * Proficient in SQL and database management, including stored procedures, views, DDL, and DML commands. * Monitored CPU utilization and optimized system performance. * Ensured data integrity through effective backup management. * Experienced in sharing analyzed data with clients in the form of comprehensive and accurate Data recon files. * Monitored ticket queues, ensuring prompt response and resolution to meet or exceed SLA (Service Level Agreement) targets. * Organized and secured confidential client documents. * Create SQL query for Extracted and analyzed data from various sources, including JSON, for business requirements. * Experienced with SSMS, Oracle DB, and PostgreSQL. * Developed and maintained client data and job functions for a new POS system. * Created reports using Power BI and Tableau for data visualization. * Monitored and maintained Azure Data Pipeline for smooth operations. * Proactively addressed SQL DB alerts to maintain system stability. * Analysis and Create Recon (reconciliation) report.
• Meeting with the IT manager to discuss system needs.
• Installing computer hardware configurations.
• Installing software and networking systems.
• Troubleshooting network and software issues.
• Installing high-level software security systems.
• Fixing hardware, software, and networking issues.
• Responding to general IT requests.
• Ensuring security software is kept up to date.