Senior Database Developer MS SQL Server

Job Description

Responsibilities

• Design stable, reliable and effective database programs to ensure that data processing production systems meet user needs
• PL/SQL and SQL Tuning and Optimization of newly develop and existing applications
• Provide data analysis and validation
• Identification of performance issues on production and testing systems.
• Interact with internal and external clients to understand requirements, explain issues and prioritize work.
• Involved in all aspects of the software development life cycle and demonstrate abilities to learn both the business processes as well as new and existing pl/sql technologies
• Understand business requirements and accordingly develop database models.
• Provide optimal design solutions to improve system quality and efficiency.
• Follow best practices for database design.
• Perform capacity analysis and oversee database tuning.
• Maintain technical documentations for reference purposes.
• Write complex codes and queries and participate in code reviews.
• Write ETL codes, update SQL statements.
• Develop monitoring tools to report any system events.
• Perform design review, modify codes and test upgrades.
• Developing complex database processes with PL/SQL containing batch or ETL functionality
• Developing and enhancing an existing DataMart in an OLAP schema
• Designing logical and physical ERD diagrams, process flow diagrams, or related data processing documentation
• Assisting Decision Support team members including DBAs, database developers, requirements analysts, and others, in understanding data and meeting user requirements
• Participating in project work groups with Subject Matter Experts and stakeholders to understand data specific needs
• Participating in performance tuning activities
• Providing production deployment and production support as needed
• Experience in developing logical and physical data models
• Provide governance to translate functional specification into technical specifications and ensure functionality and features will work with existing systems/platforms
• Any prior experience in BI tools (Business Objects/SSRS) and ETL technologies (Datastage, Informatica, SSIS) will be a strong advantage
• Should have a strong background in query tuning and performance optimization

Implementing SOX controls on new and existing databases and developing and documenting formal processes and procedures.

Key Skills: 

• Strong Hands-on in any of the database Oracle or Microsoft SQL Server OR Postgres..etc.
• Good knowledge of FLEXCUBE UBS Core, FinnOne, Penant, Finacle..etc, DDA and mainly CL/OBCL modules
• Strong-SQL development, SQL analytics and tuning skills
• Development Tools - SQL Developer, SQL Developer Data Modeler, JDeveloper
• Import / Export (Data Pump)
• Advanced SQL, Troubleshooting and Performance, Installation and Patching
• Familiarity with Middle Tier Infrastructure, i.e., Web Services, External access (JDBC, ODBC)
• Experience in performance tuning techniques like Hints, Indexing, Partitioning, joining methodologies and you are aware of how to read execution plans and deduce the best plan for the query
• Must have strong experience in TSQL programming writing SQL Queries, Joins, DDL, DML, TCL, Procedures, Functions, Triggers, Cursors, XML, JSON, Iteration (Looping) etc., 
• Must have strong experience in Table Design, Performance Tuning, troubleshooting & Debugging skills. 
• Analyse of existing SQL queries or database objects for performance improvements. 
• Must have knowledge analysis of Query plans, profiler and indexes 
• Microsoft T-SQL Server database development experience. 
• Strong understanding of relational database structures. 
• Must have strong experience in TSQL programming writing SQL Queries, Joins, DDL, DML, TCL , Procedures, Functions, Triggers, Cursors, XML, JSON, Iteration( Looping) etc., 
• Must have strong experience in Table Design, Performance Tuning, troubleshooting & Debugging skills. 
• Must have knowledge analysis of Query plans , profiler and indexes. 
• Maintain MS SQL Server databases in the development and test environments. 
• Experience in creation of MS-SQL database replications and virtualization.
• Must have knowledge on CI/CD. 
• Perform architectural reviews and code reviews
• Backup and Recovery, Storage Administration, Basic Security Administration
• Database Auditing (Audit Vault knowlege would be great)
• Scripting - Linux / Windows
• Distributed Databases
• Data Loading - Data Warehouse background & Streams
• Hands on Expertise in Microsoft Office tools including Word, Excel
• Proficiency in Backup and Recovery
• Database Administration

Experience with Database Migration, Installation, Upgrades and Patching.