Okaya Inc
Sr. SQL Developer
Okaya Inc, OAKS, PA
Job Title: Sr. SQL Developer
Location: Onsite 3 days per week in Oaks, PA - Must be Local
Duration: 6 + Months
Visa: USC,GC
Rate: $60-62/Hr. on W2 Max (Can consider a USC who has his own Corp)
End client: SEI Investments
Note: Total 8 + Years of exp. required. Must have updated LinkedIn profile. Must have Financial Domain exp.
Senior SQL Developer The Senior SQL Developer will primarily focus on development, maintenance, and support of Treasury Investor Payment application. This role will be responsible for delivery of critical product requirements and will be interacting with a culturally and technically diverse team, which includes Architects, .Net developers, SQL developers, QA and product management teams. 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
Specific Job Skills and Experience:
• 8 or more 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 -
.Creating complex queries and stored procedures
.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
Location: Onsite 3 days per week in Oaks, PA - Must be Local
Duration: 6 + Months
Visa: USC,GC
Rate: $60-62/Hr. on W2 Max (Can consider a USC who has his own Corp)
End client: SEI Investments
Note: Total 8 + Years of exp. required. Must have updated LinkedIn profile. Must have Financial Domain exp.
Senior SQL Developer The Senior SQL Developer will primarily focus on development, maintenance, and support of Treasury Investor Payment application. This role will be responsible for delivery of critical product requirements and will be interacting with a culturally and technically diverse team, which includes Architects, .Net developers, SQL developers, QA and product management teams. 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
Specific Job Skills and Experience:
• 8 or more 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 -
.Creating complex queries and stored procedures
.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