Senior Database Engineer (DBA, Data Modeling)-3 to 6 Years- Pune

About the role

Job Posting Description Are you curious, self-motivated, and forward-thinking? At FIS you'll have the opportunity to work on some of the most challenging and relevant issues in financial services and technology. Our talented people empower us, and we believe in being part of a team that is open, collaborative, entrepreneurial, passionate and above all fun. About the team - It's an amazing opportunity to join a talented team of functional and technical folks doing interesting work at the world's largest global provider dedicated to financial technology solutions! What you will be doing - Data modeling and database design - Data modelling is very important aspect of DBA activity, preferably knowledge of power designer. Database schema creation and management - A DBA must be able to translate a data model or logical database design into an actual physical database implementation and to manage that database once it has been implemented. Backup and recovery - Implementing robust backup and recovery procedures is the insurance policy of the DBA. Performance management and tuning - DBA must be able to proactively monitor the database environment and to make changes to data structures, SQL, application logic or the DBMS subsystem to optimize performance. DBA must be able to identify the performance issue in production and able to triage production issue. Data Migration - Data migration experience on Oracle/DB2/Postgres on same or across RDBMS using own built tools or third-party migration tools. Migrating database to cloud from local databases. SQL code reviews and walk -thru - DBA must possess in-depth SQL knowledge so they can understand and review SQL and host language programs and to recommend changes for optimization. Capacity planning - DBA must support more data, more users, and more connections. The ability to predict growth based on application and data usage patterns and to implement the necessary database changes to accommodate the growth is a core capability. Storage management techniques - DBAs must understand the storage hardware and software, including how it interacts with the DBMS Extensible data type administration - DBA must understand how extended data types are implemented by the DBMS vendor and be able to implement and administer any extended data types implemented in their databases (xml,json etc). Automation - As the DBA support multiple database and environments. Automation is must. Knowledge of Jenkin/Ansible will be an added advantage. Web-specific technology expertise - As DBA we support the web-based technology, DBAs are required to have knowledge of Internet and Web technologies to enable databases to participate in Web-based applications. Examples of this type of technology include XML, TCP/IP, Web servers, SSL, and so on. Troubleshooting Skills - Excellent troubleshooting skills to root cause complex issues required. Should be able to troubleshoot performance, diag logs/audit logs, security issues. Source code management tools - Experience in working with multiple source code management tools like SVN, Git and Bitbucket. Working knowledge with IaaC tools - Docker, Kubernetes, Terraform. Experience in working with multiple source code management tools - SVN, Git and Bitbucket. Cloud concepts - Preferred Experience in Cloud concepts and technologies, container build and orchestration, infrastructure-as-code, horizontal scaling CI/CD tools - Working knowledge of delivering into cloud-based environments using standard CI/CD tools and best practices What you bring: Understand technical requirements and the overall business objectives of applications. Work with the development teams to resolve and correct performance or scalability issues. Possess DevOps knowledge and experience in maintaining Git workflows for version control (source code management) Participate/contribute in developing overall automated performance-test plans to validate load, stability, scalability, and reliability standards of the application. Analyze performance test results and work with development teams to identify performance bottlenecks and their root cause. Analyze, solve, and correct issues to provide problem resolution. Collaborate with members of the development and performance teams to solve database performance and scalability problems. Work with development to discuss and review database schema design and changes. Review and help tune SQL Statements and efficiently work with various tuning tools. Research and suggest database level configuration tuning. Responsible for ensuring peak system performance (such as throughput, latency, I/O, Memory, CPU). Monitor and troubleshoot performance and scalability issues in production and internal performance labs Work in Agile environment and contribute to all agile ceremonies. Good to have Skills: Database knowledge - RDBMS, SQL, PL/SQL, experience working on Oracle/DB2/Postgres. SQL code reviews and walk -thru - DBA must possess in