Job Description Summary
Responsible for designing and programming a small module or a large component and designing a feature, set of features, or whole feature area. She/he will work independently and contribute to the immediate team and to other teams across business. She/he will Lead design discussion in a limited manner.
Job Description
Job Description
Responsible for contributing as a Database advocate for a team doing Database development and optimizing with focus on Web, SaaS and mobile platform based products.
- Rich experience in working with Microsoft SQL Server, AWS RDS, AZURE SQL
- Own medium-sized quality engineering tasks, deliver while mentoring and helping team members.
- Apply principles of SDLC and methodologies like Lean/Agile/XP, CI, Software and Product Security, Scalability, Documentation Practices, refactoring and Testing Techniques.
- Integrate project testing with continuous-integration process.
- Work with fellow team members to diagnose bugs and formulate solutions.
- Provide expertise in the quality engineering, test planning and testing methodology for a software project and keeps abreast of evolving QA industry processes and standards.
- Develop and execute maintainable automation tests for acceptance, functional, and regression test cases.
- Master the basics of underlying Manufacturing domain.
Desired Characteristics & Technical Expertise
- Bachelor's Degree in Computer Science or in STEM Majors (Science, Technology, Engineering and Math)
- A minimum of 8 to 12 years of Software Testing experience with Web or SaaS Platform based products, SQL Server databases.
- At least 8 years of experience in owning modules and mentoring teammates.
- Bachelor's degree in computer science or in STEM Majors (Science, Technology, Engineering and Math)
- Development of high quality and high performant database solutions
- Performance Tuning and Optimization of stored procedures and functions using T-SQL
- Experience with Schema Modelling and Data Modelling, CLR functions, BCP process, bulk import process
- Develop, implement, optimize, review and interpret ongoing business report requirements.
- Experience in Debug and Troubleshoot Complex Stored Procedures and functions.
- Experience in researching required data and build appropriate and useful reporting deliverables Analyze existing SQL queries for performance improvements.
- Develop procedures and scripts for data migration Provide timely scheduled management reporting experience.
- Excellent understanding of T-SQL programming Excellent understanding of Microsoft SQL Server.
- Experience in Transparent Data Encryption (TDE) ,Partitioning (Vertical and Normalization), HA-DR (Clustering - Always On & Availability Groups)
- Experience in DBA Activities (Index Maintenance, DB files management, SQL agent Jobs troubleshooting)
- Source Control CI-CD process using SVN, GitHub etc
- Working knowledge on cloud technologies (AZURE, AWS)
- Experience testing hosted or SaaS-based solutions.
- Familiar with relational database design and good working knowledge of SQL for querying, updating, and deleting data.
- Strong proficiency with functional, regression, performance and stability testing techniques.
- Experience working in a cross-functional development team with the ability to influence quality of products in that environment.
- Demonstrates the initiative to explore alternate technology and approaches to solving problems.
- Skilled in breaking down problems, documenting problem statements and estimating efforts.
- Strong oral and written communication skills.
- Effective team building and problem-solving abilities.
Business Acumen
- Has the ability to break down problems and estimate time for development tasks.
- Understands the technology landscape, up to date on current technology trends and new technology, brings new ideas to the team.
- Displays understanding of the project's value proposition for the customer. Shows commitment to deliver the best value proposition for the targeted customer.
- Learns organization vision statement and decision-making framework. Able to understand how team and personal goals/objectives contribute to the organization vision
Leadership Attributes
- Voices opinions and presents clear rationale. Uses data or factual evidence to influence.
- Learns organization vision statement and decision-making framework. Able to understand how team and personal goals/objectives contribute to the organization vision.
- Completes assigned tasks on time and with high quality. Takes independent responsibility for assigned deliverables.
- Has the ability to break down problems and estimate time for development tasks.
- Seeks to understand problems thoroughly before implementing solutions. Asks questions to clarify requirements when ambiguities are present.
- Identifies opportunities for innovation and offers new ideas. Takes the initiative to experiment with new software frameworks
- Adapts to new environments and changing requirements. Pivots quickly as needed. When coached, responds to need & seeks info from other sources
Additional Information
Relocation Assistance Provided: Yes
