Job Summary: The mission of the Database Engineer on the DB team is to develop and optimize complex SQL queries, stored procedures, functions, and views. The Database Engineer demonstrates resourcefulness, takes direction, provides direction, and learns new technologies to support the business. The responsibilities of this position include designing, implementing, and maintaining our SQL Server databases, in a dynamic team environment.
Duties/Responsibilities:
- Collaborates with clients and/or internal teams to understand user needs; collaborates on initial proposal and design of software to meet these needs.
- Design, implement, and maintain robust SQL Server database systems.
- Develop and optimize complex SQL queries, stored procedures, functions, and views.
- Develops ETL, Data Warehouse, Data Vault, Data Modeling, Big Data, and Data Migration tasks.
- Collaborate with development teams to design efficient data models and ensure seamless integration with applications
- Participate in architectural and design discussions to ensure APIs align with business goals.
- Monitor and optimize database performance by fine-tuning queries, indexing strategies, and resource allocation.
- Work with cross-functional teams to plan and execute database upgrades, migrations, and integrations.
- Provide technical support and troubleshooting for database-related incidents and queries
- Diagnose and resolve database-related issues, ensuring minimal downtime and high availability.
- mplement performance monitoring and alerting systems to proactively manage potential issues.
- Designs data models and database schemas for specific application areas.
- Collaborates with systems analysts, engineers, and programmers to design systems to support required applications.
- Document database architectures, configurations, and processes to ensure maintainability and compliance.
- Performs other related duties as assigned.
- Able to work 2nd-shift (3PM to 12 midnight), Mondays to Fridays
- Effective verbal and written English communication skills
Desired Qualifications:
- Bachelor’s degree in computer science, engineering, or related field required.
- At least five years of experience as a software developer or database engineer required.
- Experience with Azure cloud services and platform is preferred.
- Strong proficiency in SQL and experience with database performance tuning, query optimization, and index management.
- In-depth knowledge of backup and recovery strategies, high availability, and disaster recovery solutions for SQL Server.
- Familiarity with scripting languages (e.g., PowerShell) for automating database tasks.
- Experience working with SQL and writing queries for relational databases.
- Familiarity with relational databases (SQL Server, etc.) and designing efficient queries.
- Experience with cloud-based database services (e.g., Azure SQL Database) is a plus.
- Experience with data warehousing, ETL processes, or big data technologies
- Knowledge of additional database platforms and modern data architecture patterns.
- Excellent time management skills with the proven ability to meet deadlines.
- Ability to participate in Agile sprinting and ceremonies.
JSSI does not accept unsolicited resumes from individual recruiters or third-party recruiting agencies in response to job postings. No fee will be paid to third parties who submit unsolicited candidates directly to our hiring managers or Recruiting Team.
Report job
