A company is looking for a
Sr. QA Automation Engineer Assistant Vice President.
What you will be responsible for:
Database Design and Architecture
- Design and implement scalable, performant and highly available distributed database solutions
- Collaborate with peers across scrum teams to design and deliver database design conforming to database best practices and meet business and application requirements
- Create and maintain comprehensive documentation of database design, data models, configurations, and processes
Database Development and optimization
- Write complex SQL queries, stored procedures, and script to support application development
- Optimize performance through indexing, SQL query optimization, and other database tuning techniques
- Monitor database performance metrics, analyse and identify bottlenecks, and recommend short-term and long-term solutions
- Collaborate with engineering teams to define performance test strategy, and develop toolsets to generate synthetic datasets for effective and repeatable performance tests
- Implement and manage database security, including access controls, encryption, and auditing
Database Administration
- Perform database installation, configuration, and upgrades
- Monitor and maintain database health to ensure data integrity, availability, and disaster recovery
- Collaborate with production DBA team to troubleshoot and resolve database production issue in timely manner
Collaboration and Leadership
- Provide thought leadership on the topic of database technologies and data modelling within and beyond the team's scope of responsibility
- Collaborate with cross-functional teams, including engineering, SaaS Operation, support, and implementation, to ensure seamless integration of database systems
- Provide technical mentorship to junior database engineers
What We Value
- Extensive hands-on experience in RDBMS and distributed data platforms as a database developer or DBA
- Strong analytical and problem-solving skills with ability to troubleshoot and resolve database related issues
- Proficiency in SQL performance tuning in MS SQL Server, Oracle, or Snowflake
- Experience in NoSQL databases is preferred
- Experience with cloud database services such as Azure SQL Database or AWS RDS is a plus
- Programming experience in Java, C++, C#, JDBC, Sprint boot, and Microservices is a plus
- Experience with developing applications for the financial markets is a plus (Fixed Income, Trading, FX, Risk, Portfolio/Wealth Management, Market Data, FIX, etc.)
Education & Preferred Qualifications
- 10+ years of professional software engineering experience with enterprise applications backed with RDBMS databases or Snowflake
- Bachelor's degree in computer science, Information Technology, or a related field. Master's degree is a plus
- Expert experience with relational databases (RDBMS), hardware sizing and configuration, operating systems, scripting, and database technologies
- Strong track record of building high performance, production quality software on schedule
- Ability to work independently, handle multiple tasks simultaneously and adapt quickly to changes
- Excellent communication skills (verbal and written) with the ability to convey complex technical concepts to both technical and non-technical stakeholders
- A minimum of 5 years working with an Agile development methodology strongly desired
#JPKR
#JPKR
