Specialist Systems engineer - Database Administration Societe Generale Global Solution Centre

5.0 - 9.0 years

0 Lacs

karnataka

On-site

As an MS-SQL DBA L2, you will be responsible for providing 24*7 database support including incidents, requests, and changes. This includes offering on-call support during weekends and out of business hours, as well as ensuring 24x7 support for critical production systems. Your role will involve a strong understanding of Production Database Operations and the importance of Business-As-Usual (BAU) operations. Additionally, you should have good knowledge of the ITIL Framework and possess effective communication skills both in written and verbal forms. You will be expected to have experience in Incident Management, handling crisis calls by engaging with vendors and clients, and demonstrating strong analysis skills, problem-solving abilities, and decision-making skills. It is important that you are willing to take responsibility and ownership of problems, as well as continuously upskill yourself on new concepts, features, and open-source technologies while acting as a mentor to others. In this role, you will be required to work in a rapidly changing environment, plan and execute PSU Patching and Upgradation of SQL Server, and have experience in automating PSU Patching and other routine tasks. Your responsibilities will also include account management, performance monitoring, optimizing queries, managing security parameters, handling backups, and troubleshooting SQL Agent Jobs and Maintenance Plans. To be successful in this position, you must have good team working skills, the ability to work in shifts on a 24x7 rotation basis, and a positive attitude. Strong knowledge of Production Database Operations, ITIL Framework, and experience in Incident Management are essential. Additionally, proficiency in presentation skills, project management, and troubleshooting data corruption are highly valued. Ideally, you should have 5-8 years of experience in a similar role, hold an engineering or computer science degree, and possess relevant RDBMS certifications. Experience in handling a large environment with a minimum of 500+ SQL instances and TBs of database size is considered advantageous. Join us at Socit Gnrale, where we believe in the power of individuals to drive change and shape the future. If you are looking for a stimulating environment where you can grow, innovate, and make a positive impact, then we welcome you to be part of our team. Our commitment to diversity, inclusion, and ESG principles ensures that you will have the opportunity to contribute meaningfully to our activities and policies while growing both personally and professionally.,

Posted 2 days ago

Apply

Oracle DBA - SBI Securities Sbicap Securities

3.0 - 8.0 years

15 - 19 Lacs

Mumbai

Work from Office

Role & responsibilities Database Management: Lead, Manage, Migrate, Upgrade and optimize RDBMS oracle databases ensuring high availability, scalability, and performance. Database Architecture & Design: Work with application development teams to design and implement database architectures, including schema design, indexing strategies, and partitioning. Performance Tuning & Optimization: Proactively monitor and fine-tune database performance, identifying bottlenecks and applying optimizations to improve query execution times and system responsiveness. Backup & Recovery: Develop/Design backup strategies and disaster recovery planning to ensure business continuity and data integrity. Automation & Scripting: Develop and implement automation scripts for database maintenance, backups, and monitoring using shell script or tool. Security & Compliance: Implement and enforce database security policies, including encryption, access control, and auditing, to meet compliance and regulatory standards. Incident Management & Troubleshooting: Lead the response to production database issues, ensuring quick resolution and minimal downtime. Collaboration: Work closely with engineering, DevOps, and other teams to ensure seamless integration between database systems and applications. Research & Innovation: Stay up-to-date with the latest trends and technologies in RDBMS/ Oracle databases and recommend new tools or methodologies to improve system performance and capabilities. Preferred candidate profile Oracle Certified DB Professional (OCP) 3+ years of hands-on experience with Oracle databases in a Banking/financial mission critical production environment. Should be able to work in 24*7 production database support environment. Proactively monitor, manage and maintain to ensure DB availability for single as well as RAC database environment. Managing tablespaces, user quota, rollback segments, user maintenance, database security imposition by user creation assignment of roles and privileges. Hands on experience required on Database Upgradation/ Migration on Oracle 12c, 19c and single/RAC instance. Should have sound experience in Oracle 12c, 19c with Installation, Configuration, Upgrades, Administration, Backup and Recovery, Disaster Recovery and Patching. Experience should include capacity planning, performance tuning, space management, backup and recovery, managing schemas and DB clustering technologies. Strong practical experience of ORACLE in a production RAC Installation, Administration, PSU Patching and ASM storage management. Should have Operating system experience in Linux/Windows and UNIX Scripting. Performed manual Drill Switchover and Switchback on multiple databases (Single Instance/RAC) as a part of DR-Drill activity. Should be able to use Oracle management tools (Data Guard, RMAN, Data pump/ Export-import), experience in clone/refresh Schema, database from Production to Test and Development Environment. Deep knowledge of database performance tuning, query optimization, and storage management. Strong knowledge in analysing AWR/ TKPROF report for database performance issue and able to handle the severity-1 issues in production. Experience with designing and implementing backup strategies and disaster recovery plans. Should have worked on database security practices, including Encryption/Redaction/Oracle Vault, user access control, and compliance standards. Strong analytical and troubleshooting skills in a high pressure environment. Excellent communication skills and ability to work effectively across the teams.

Posted 1 week ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.