Job Description

Pune, IN-MH
Position Type
Full Time


Requisition ID
11508


Level of Education
Years of Experience
5+ to 7 Years


About Exela


Exela is a business process automation (BPA) leader, leveraging a global footprint and proprietary technology to provide digital transformation solutions enhancing quality, productivity, and end-user experience. With decades of expertise operating mission-critical processes, Exela serves a growing roster of more than 4,000 customers throughout 50 countries, including over 60% of the Fortune 100. With foundational technologies spanning information management, workflow automation, and integrated communications, Exela's software and services include multi-industry department solution suites addressing finance & accounting, human capital management, and legal management, as well as industry-specific solutions for banking, healthcare, insurance, and public sectors. - Through cloud-enabled platforms, built on a configurable stack of automation modules, and 17,500+ employees operating in 23 countries, Exela rapidly deploys integrated technology and operations as an end-to-end digital journey partner.




Health & Wellness


We offer comprehensive health and wellness plans, including medical, dental and vision coverage for eligible employees and family members; paid time off; and commuter benefits. In addition, supplemental income protection including short term insurance coverage is available. We also offer a 401(k)-retirement savings plan to assist eligible employees in saving for their retirement. Participants are provided access to financial wellness resources and retirement planning services.





Military Hiring:


Exela seeks job applicants from all walks of life and backgrounds including, but not limited to, those who are transitioning military members, veterans, reservists, National Guard members, military spouses and their family members. Individuals will be considered no matter their military rank or specialty.


Replacement

We are looking for a SQL developer who will be responsible for designing databases and ensuring their stability, reliability, and performance. You will also work with other developers optimizing in-application SQL statements as necessary, and establishing best practices. You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future. Responsibilities • Create a Database and normalize the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Well versed with the DDL and DML statements
• Help write and optimize in-application SQL statements
• Creating and maintaining complex stored procedures , Extended System SP , Triggers , views , Tables , user defined functions, DBCC commands .
• Create indexes and analyse its role for optimizations
• Develop Dynamic search queries and results with manipulated data.
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures such as upgrade, backup, recovery, migration, etc.
• Implement SQL Logins, Roles and Authentication Modes as a part of Security Policies for various Categories of users.
• Create Linked server and running distributed queries to access data from other remote servers.
• Follow the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services (SSIS) , including upgrading DTS to SSIS.
• Prepare different types of reports using SSRS .

Skills & Qualifications • Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferred
• Good experience of IT industry with strong understanding of database structures, theories, principles, and practices
• 2 - 4 years Microsoft SQL Server experience (2008 / 2012 / 2014)
• Understanding of, and experience with, server-client computing and relational database environments
• Experience with data management and data processing flowcharting techniques
• Knowledge of reporting and query tools and practices
• Good interpersonal, written, and oral communication skills
• Ability to present ideas in user-friendly language
• Self-motivated and directed, with keen attention to detail
• Able to prioritize and execute tasks in a high-pressure environment
• Experience working in a team-oriented, collaborative environment

Responsibilities

• Well versed with the DDL and DML statements

• Help write and optimize in-application SQL statements

• Creating and maintaining complex stored procedures, Extended System SP, Triggers, views, Tables, user defined functions, DBCC commands.

• Create indexes and analyze its role for optimizations

• Develop Dynamic search queries and results with manipulated data.

• Ensure performance, security, and availability of databases

• Prepare documentations and specifications

• Handle common database procedures such as upgrade, backup, recovery, migration, etc.

• Implement SQL Logins, Roles and Authentication Modes as a part of Security Policies for various Categories of users.

• Create Linked server and running distributed queries to access data from other remote servers.

• Follow the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services (SSIS), including upgrading DTS to SSIS.

• Prepare different types of reports using SSRS.

Skills & Qualifications

• Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferred

• Good experience of IT industry with strong understanding of database structures, theories, principles, and practices

• 2 - 4 years Microsoft SQL Server experience (2008 / 2012 / 2014)

• Understanding of, and experience with, server-client computing and relational database environments

• Experience with data management and data processing flowcharting techniques

• Knowledge of reporting and query tools and practices

• Good interpersonal, written, and oral communication skills

• Ability to present ideas in user-friendly language

• Self-motivated and directed, with keen attention to detail

• Able to prioritize and execute tasks in a high-pressure environment

• Experience working in a team-oriented, collaborative environment

Disclaimer:
Exela is committed to creating a diverse environment and is proud to be an equality opportunity employer. Qualified applicants will considered for employment without regard to their race, color, creed, religion, national origin, ancestry, citizenship status, age, disability, gender/sex, marital status, sexual orientation, gender identity, gender expression, veteran status, genetic information, or any other characteristic protected by applicable federal, state, or local laws.


Exela recruiters or representatives will only contact you from emails ending with @exelaonline.com, @exelatech.com, @lexicode.com, @rustconsulting.com or @ersgroup.com. We would never ask you for payment or ask you to deposit a check into your personal bank account during the recruitment process.