Senior Software Engineer

Job Description

Job Title: Senior Software EngineerDivision: Legal SolutionsDepartment: EDSLocation: HyderabadReports To: Sr. Product Development ManagerSummaryThe Legal Solutions team within Legal Services is growing, and we are looking for a Senior Software Engineer who is an experienced DB developer.The Senior Software Engineer will be responsible for expanding and optimizing our DB programming capabilities as part of Legal Solutions team. The ideal candidate is a seasoned MS-SQL, Azure SQL developer who enjoys assessing and understanding DB systems; design schemas; writes intermediate to advanced SQL queries, stored procedures, user defined functions; conduct database trouble shooting to ensure their (databases) stability, reliability, and performance.Qualification and Requirements:

• Bachelors /Master s Degree in Information Science or Computer Science required B.Tech, MCA, MS Computers.

Essential Skills :

• 6 years of relevant experience as a backend DB developer on Microsoft SQL server, Azure SQL, Snowflake Datawarehouse.
• Very strong experience in designing DB schemas, Ability to analyze databases to identify DB design issues and optimize them for usage and performance.
• Very strong SQL Server skills for querying and creation of views/tables, functions and stored procedures, UDF and Triggers
• Very strong experience on T-SQL, Query optimization and performance tuning.
• Experience in Azure SQL Plan, Deploy and Verify Azure SQL
• Experience in Snowflake DW Create Snowflake Objects, Stage the Data Files, Copy Data into Target Table, Query the Loaded Data, Uploading Data from Snowflake, Sharing Data Securely in Snowflake.
• Experience in database design and understanding data models, OLTP systems.
• Experience in Online Analytical Processing (OLAP) and ETL (Extract, transform, load) framework.
• Experience into using the tools like profiler and extended events.
• Experience working in Agile Scrum methodology.
• Must have experience in all phases of the Software Development Life cycle.
• Proactive issue resolution with a positive attitude.
• Strong analytical and reasoning skills with an ability to visualize processes and outcomes.
• Proficiency in troubleshooting software issues and debugging existing database objects and improvise them.
• Outstanding all-round communication skills and ability to work collaboratively.

Nice to have (profiles with following skills will have preference over the rest):

• Knowledge and basic experience in SSIS, SSRS, ADF.
• Background in data warehouse design (e.g. dimensional modeling)

• Exposure to designing ETL processes including knowledge of data warehousing strategies and theories.
• Adept in developing, publishing and scheduling SSIS packages and SSRS reports as per the business requirements.
• Understanding of Legal Services domain is an added advantage.

Job Responsibilities:

• Investigating business systems from databases perspective, taking a holistic view of the situation, including key stakeholder needs as well as current processes and IT systems.
• Working collaboratively internally to deliver chosen solutions.
• Develop database schemas and tables.
• Implement indexes and design the relationships and constraints between database tables.
• Develop, implement and optimize stored procedures and functions using T-SQL.
• Fix any issues related to database performance and provide corrective measures.
• Handle common database procedures such as upgrade, backup, recovery and migration.
• Load and unload data in Snowflake DW and manage the Cloud DB.
• Setup different views as need be in Snowflake (Secure Views, Materialized Views).
• Write intermediate to advanced queries for Snowflake DW.
• Administer and monitor Snowflake computing platform.
• Create Azure SQL - Single Databases and/or Elastic Pools.
• Querying Azure SQL using Azure Portal, Azure Data Studio, SSMS, VS Code, .NET with Visual Studio, .NET Core.
• Write intermediate to advance Azure SQL queries.
• Querying Azure SQL distributed data.
• Setup monitoring tools and report Database performance statistics periodically and take necessary actions.
• Continuously evolve by learning new areas of SQL Server, Azure SQL and Snowflake as needed by the project.
• Resolve technical DB issues for the team and mentor junior members to scale up on technology, design and implementation approaches.
• Responsible for design methodology and project documentation.
• Own complete end to end delivery of Database solutions across MS-SQL, Azure SQL, Snowflake DW.
• Should be highly motivated with a strong sense of commitment towards work.

CompetenciesIntegrity Behaves in an honest, fair and ethical manner; shows consistency in words and actions; does what she/he commits to doing; respects the confidentiality of information or concerns shared by others; is honest and forthright with people; carries his/her fair share of the workload; takes responsibility for own mistakes.Client Focus Takes action with the clients, both internal and external, and sees their needs as a primary focus; builds a sustaining collaborative and productive relationship with clients; seeks to understand client situations, issues, expectations, etc.; takes appropriate action to meet client needs and address concerns; implements or utilizes methods to monitor and evaluate client feedback.Results-Driven Sets stretch goals for personal and team accomplishment and works tenaciously to achieve those goals; acts with a sense of urgency; takes the initiative on actions; identifies what needs to be done and takes action before being asked; does more than what is normally required in a situation; establishes metrics to monitor progress and measure success; maintains focus by avoiding or overcoming roadblocks.Entrepreneurial Orientation Proposes innovative business opportunities/ideas to customers and business partners; encourages and supports entrepreneurial behavior in others; demonstrates willingness to take calculated risks to achieve business goals.Decisiveness Makes well-informed, effective and timely decisions even when data is limited or solutions produce unpleasant consequences; perceives the impact and implications of decisions; has the ability to make tough decisions.Work EnvironmentWork is fast-paced and performed in an environment with extensive contact with clients and employees. The industry we serve demands the highest level of confidentiality and professionalism in safeguarding client and project information. Highly effective Legal Solutions associates thrive on being in an environment that rewards the following critical success factors:Adaptability: Appropriately reacting to changing situations without a loss of effectiveness and enthusiasm for strategic initiatives and corporate goals. Analysis: Identifying problems and causes or analyzing how processes and procedures could be improved, collecting relevant information and identifying possible solutions. Attention to Detail: Appropriately completing all of the individual tasks accurately or according to workflow/process guidelines with an emphasis on reaching or exceeding quality standards. Creativity: Being inventive, imaginative and innovative. Development of Others: Providing the means for others to grow and develop personally and professionally within and across departments. Energy: Maintaining a fast, active pace in the normal course of a day. Flexibility: Going into situations without preconceived notions with a willingness to assess various options in order to determine a course of action. Integrity: Strict adherence to job-related standards, values or norms. Learning Ability: Understanding and applying new information. Listening. Hearing and comprehending verbal messages and confirming back what you hear. Team Player: Functioning as an active member of a group while maintaining focus on your individual contributions and responsibilities. Verbal & Written Communication: Effective oral, written and nonverbal expression without preparation.,

Keyskills :
javadatabase designjavascriptcustomer relationssqldata warehousingmicrosoft sql servermonitoring toolsms sqlend to end deliverysql queriessql serverdata modelsvisual studio