SQL Developer

Description:

Client: SEI Investments Company


Location: Oaks, PA (Hybrid-3 days onsite in a week)


Overview:


The SQL Developer will primarily focus on development, maintenance, and support of Platform applications. This role will be responsible for delivery of critical product requirements and will be interact with a culturally and technically diverse team, which includes .Net developers, SQL developers, QA and product management teams.


Specific Job Skills and Experience:

• 5+ years of related experience; or equivalent combination of education and experience
• Experience with the full software development life cycle, including design, testing, deployment, and documentation activities (including agile and scrum patterns)
• Advance SQL development skills like -
• In-depth understanding of data modeling best practices, normalization techniques, and database design patterns Advanced Knowledge in Always On, Transactional Replication, Clustering and T-SQL
• Proficiency in writing complex SQL queries, stored procedures, functions and triggers.
• Experience with SQL BI stack or SSRS, SSIS and PowerBI.
• Must have experience in source controls GitHub and bitbucket.
• Knowledge in scripting/programing languages: PowerShell, Bash, Python.
• High level of knowledge of Windows Server and WSFC with an understanding of things needed to manage HA and DR as well as troubleshoot performance and connectivity.
• Extensive experience with PowerShell and creating your own modules for management and automation in SQL Server environments (beyond basic use of community created modules such as DBA Tools).
• Performance tune complex queries and query optimization.
• Developing Dynamic SQL and stored procedures.
• Using indexes to speed up the SQL queries.
• Experience in creating database schemas that represent and support business processes.
• Extensive knowledge and hands on experience designing and developing objects and components of relational and non-relational database.
• Full Text Searching
• Developing ERD - both physical and logical.
• Strong experience with Agile methodologies
• Knowledge and understanding of SDLC, with a strong preference for Agile experience.
• Skill for writing reusable functions, views and database objects.
• Excellent written/verbal communication, presentation, and listening skills.
• Excellent collaboration/teamwork skills.
• Understanding of fundamental design principles for building a scalable application
• Familiar with various design and architectural patterns.

Essential Functions/Responsibilities:

• Can help in defining, documenting and developing software, software applications, as well as contributes to architecture and technical design discussions, code reviews and technical design/specifications in collaboration with the project team.
• Independently responsible for development, enhancement, testing, support, maintain and troubleshoot/ debug software applications that support business units or support functions.
• Create thorough, professional quality project documentation and technical specifications.
• Assesses the impact of software changes and new development on other systems; conducts integration tests to mitigate risks.
• Mentor junior team members and participates in and promotes a knowledge-sharing environment.

Enable Skills-Based Hiring No ICIMS RR ID #
Additional Details

• Skill Category : Regular
• ICIMS RR ID # : NA
• Client Name : SEI Investments Company
• Engagement Type : T&M Competitive 1-3
• Vertical : BFSI
• Must-Have Primary Skill : Application Management-Development-SQL Server-SQL, T-SQL, SSIS
• Primary Skill: Yrs Experience : Expert (5+ Years Experience)
• RC- Domain : Web & E-commerce applications
• RC- Subdomain : 144 - Other Web Applications(Angular JS, Solution Architechture API, Fortran, Python ,Application Support, Oracle, OAM, Weblogic)
• RC- Role : Developer
• RC- Experience Level : IV
• RC- Geo Tier : US-3
• RC- Exception Required : TBD
• COVID-19 Vaccine Required? : No
• Client-Accepted Visa Types : Citizen Only,EAD,H-1,Perm Resident/Citizen only