LOCAL CANDIDATES 

Role Description:

We are looking for a creative and talented Lead Database Developer with MS SQL Server experience and leading teams with varied skillsets. A successful candidate will have an eye for quality and detail to help the team build sophisticated and high performing applications for the Institutional Consulting . 

The candidate will be part of a global team delivering database solutions using agile methodologies.

Job Functions/Duties and Responsibilities:

* Collaborate with peers to deliver high quality work by established deadlines.

* Identify potential issues while staying focused on identified priorities.

* Build high-quality reusable code that can be used as a framework for data integration.

* Solve production issues as needed and participate in technical design sessions.

* Work with the team in data modeling, database design, creating efficient SQL for fast application performance.

* Ensure databases provide required functionality to meet the business needs and maintain data integrity.

* Ensure performance of a large databases.

* Handling one or more assignments simultaneously with effective offshore support

* Document business and functional requirements, including data flow, business rules, and stories.

* Assess the impact of changes on existing business and technology processes, as well as other interfacing systems.

* Work with geographically dispersed teams (NYC, Alpharetta, Mumbai, and Bangalore).

* Manage teamsSkills Required:* Financial industry experience.

* Strong understanding of RDBMS concepts with excellent problem-solving skills.

* At least, 15-20 years of IT experience using database technologies, preferably MS SQL Server.

* Advanced experience in Data modeling, relational database design and hands on database development using SQL Server.

* Expert in writing, debugging, optimizing and performance tuning of stored procedure, views, triggers, UDFs and complex queries.

* Expert in Database optimization and performance tuning.

* Experience with SQL Server Integration Services (SSIS).

* Experience in Data warehouse and reporting & analytical environments.

* Experience with both traditional Waterfall SDLC and Agile methodologies.

* Good communication and presentation skills: ability to communicate in a clear and concise manner, across all stakeholder groups.

* Proven ability to work in a fast-paced cross-functional team environment.

* Understanding of requirements of large enterprise applications (security, entitlements, etc.)

* Experience with task management tools such as JIRA.

* Experience leading and managing teams

Desired Skills:* Informatica* Power BI* Tivoli Workload Scheduler* Autosys