SQL Developer

Job Description

In order to be successful it is expected that you are proficient with relational database concepts and practices, are able to evaluate and write SQL queries, and can create and maintain common database objects such as views, stored procedures, and user-defined functions. Additionally, you should be able to utilize code management and/or revision control tools and follow standard software development practices at an expert level. The majority of time is spent developing and refining ETL processes, writing update queries, and writing ad-hoc queries on behalf of clients and stakeholders. Expertise with following;

• Microsoft SQL server and SQL based queries
• Source control
• With MS SQL database development
• Using indexes, common table expressions, temp tables to optimize large SQL queries
• Creating tables and stored procedures, as well as best practices to creating tables and stored procedures
• Able to use SSIS and SSRS

Proficient with;

• In SQL Server database administration and data modeling
• With MS SQL database development for optimized query performance on OLTP databases
• Able to present complex and/or technical material in an understandable manner to technical/non-technical audiences and decision-makers to aid them in their decisions
• Adhere to published coding standards and documentation requirements.

Meet the following requirements;

• Able to write and optimize in-application SQL statements
• Ensure performance, security and availability of databases
• Knowledge of best practices and database-design when dealing with Relational Databases (OLTP Systems)
• Capable of troubleshooting common database issues
• Proactively analyze, assess, and identify problematic areas of batch processing, production jobs, and production workflow; work to address the issues you ve identified, helping to make our solutions more robust and stable.
• Evaluate data quality processes and resolve data quality issues.
• Conduct code walkthroughs, peer reviews, and produce technical documentation.

Qualifications

• BE/B.Tech/MCA Computer Science or related discipline, or equivalent industry experience
• 5 years hands-on experience with MS SQL Server, 2008 R2 or higher, as a developer.
• Competent SQL skills, able to create and to evaluate SQL statements involving numerous tables and complex relationships.
• Ability to work in an environment with deadlines and shifting priorities.
• Expert at writing performant queries and can assist others with tuning
• Deep knowledge of the functions available with SQL Server and how they operate and when they should be used
• Experience developing and maintaining ETL procedures.
• Ability to communicate effectively, both verbally and in writing; able to adjust for intended audience. Fluency in English.

Competencies Integrity 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 Environment Work is fast-paced and performed in an office 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 Class Action & Claims Solutions and Corporate Services 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.

Physical DemandsThe work environment characteristics described here are representative of those an associate encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essentials functions.

• Position requires no significant manual labor.
• Position does require moderate standing, sitting, carrying and walking.
• Position requires infrequent lifting, repetitive bending and/or moving.
• Position requires close vision, distant vision, peripheral vision, and depth perception.
• Position requires talking and listening to communications with clients and employees.

#LI-VR1If you like wild growth and working with happy, enthusiastic over-achievers, youll enjoy your career with us!It is Epiq s policy to comply with all applicable equal employment opportunity laws by making all employment decisions without unlawful regard or consideration of any individual s race, religion, ethnicity, color, sex, sexual orientation, gender identity or expressions, transgender status, sexual and other reproductive health decisions, marital status, age, national origin, genetic information, ancestry, citizenship, physical or mental disability, veteran or family status or any other basis protected by applicable national, federal, state, provincial or local law. Epiq s policy prohibits unlawful discrimination based on any of these impermissible bases, as well as any bases or grounds protected by applicable law in each jurisdiction. In addition Epiq will take affirmative action for minorities, women, covered veterans and individuals with disabilities. If you need assistance or an accommodation during the application process because of a disability, it is available upon request. Epiq is pleased to provide such assistance and no applicant will be penalized as a result of such a request. Pursuant to relevant law, where applicable, Epiq will consider for employment qualified applicants with arrest and conviction records.,

Keyskills :
leadership skillssql serverbatch processingmusic makingdata servicesdata flowpeer reviewsms sqlequal employment opportunitybusiness systemdatabase administrationssrscomputer sciencesql databasems sql serverssissql queriessqlcoding standa