Senior Database Engineer (DBA, Data Modeling)-3… at Fidelity… · Pune

Senior Database Engineer (DBA, Data Modeling)-3 to 6 Years- Pune Location: IND PUNE FL7 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 IaaCtools - 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-depth SQL knowledge so they can understand and review SQL and host language programs and to recommend changes for optimization. Procedural skills - The DBA must possess procedural skills to help design, debug, implement, and maintain stored procedures, triggers, and user-defined functions that are stored in the DBMS. Data security - DBA is in charge with the responsibility to ensure that only authorized users have access to data. This requires the implementation of a rigorous security infrastructure for production and test databases. And a database auditing capability to document compliance. Troubleshooting Skills - Excellent troubleshooting skills to root cause complex issues required. Should be able to troubleshoot performance, diag logs/audit logs, security issues. Scripting Language - Python/ bash/ksh Shell/Perl/awk Database deployment tool – Liquibase. Working experience in Agile development, and Test-Driven Development. Preferred Experience working with Cloud platforms such as AWS/Azure/Google Cloud. AWS certification is a plus. Preferred Knowledge of Banking or Financial Domain. Strong analytical, problem-solving skills and ability to lead others. Possesses strong communication skills (verbal and written) with good listening capabilities. Willingness and ability to learn and take on challenging opportunities. Strong Team Player, interpersonal & presentation skills. Qualifications Bachelor (BE/BTech) or master’s degree in computer science or related field. 3+ years of hands-on experience of Java software design & development Competencies Fluent in English. Excellent communicator – ability to discuss technical and commercial solutions to internal and external parties and adapt depending on the technical or business focus of the discussion. Attention to detail – track record of authoring high-quality documentation. Organized approach – manage and adapt priorities according to client and internal requirements. Self-starter but team mindset - work autonomously and as part of a global team. What we offer you At FIS, we value your expertise, and offer growth, opportunities, and a competitive compensation and benefits package in a casual work environment. Are you ready to help us transform the world of Digital Banking? Then apply and find out more about us. Privacy Statement FIS is committed to protecting the privacy and security of all personal information that we process in order to provide services to our clients. For specific information on how FIS protects personal information online, please see the Online Privacy Notice. Sourcing Model Recruitment at FIS works primarily on a direct sourcing model; a relatively small portion of our hiring is through recruitment agencies. FIS does not accept resumes from recruitment agencies which are not on the preferred supplier list and is not responsible for any related fees for resumes submitted to job postings, our employees, or any other part of our company. #pridepass