Job Description
Were in search of an experienced SQL Developer to lead in the development of SQL databases for a wide variety of applications and business uses. You should bring experience with data architecture and management to develop and scale SQL databases based on organizations needs. Moreover, youll need to write SQL queries to store, sort, and retrieve a range of data. You should be a quick thinker, highly organized and able to troubleshoot any number of issues that can come up during the day-to-day operations.
Responsibilities:
- 3 - 5 years of experience in Development of high-quality database solutions, using PostgreSQL.
- Develop, implement and optimize stored procedures and functions using SQL & PL/pgSQL.
- Review and interpret ongoing business report requirements.
- Research required data.
- Analyze existing SQL queries for performance improvements.
- Develop procedures and scripts for data migration.
- Familiar with performance tuning such as indexes, partitions, clustering.
- Familiar with pg extensions - pg_trgm, pg_crypto.
- Familiar with different indexes - btree, gin, gist.
- Familiar with JSON data format & in-built Postgres JSON/JSONB functions.
- Ability to write a complex SQL, given a requirement.
- Ability to understand & troubleshoot machine-generated SQL code.
- Install/upgrade PostgreSQL.
- Familiar with cross-database IDEs - Dbeaver, DBVisualizer, TOAD etc.
- Familiar with PostgreSQL CLI psql.
- Familiar with database migrations using Flyway, Liquibase.
- Familiar with code version control in GitHub.
- Understanding of REST APIs will be an added advantage.
- Create SQL views, Common Table Expressions (CTEs) and stored procedures to combine/aggregate data needed for reporting purposes.
- Use ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
- Familiarity with Software Engineering development cycle (SDLC)
- Ability to communicate and work well in Agile/SAFE/Scrum team-based environment.
- T-SQL, Performance tuning, SQL Server SSIS, Reporting Service Qualifications Skills.
- Reporting and business intelligence tools like Microsoft SQL Server Reporting Services (SSRS) and SAP Crystal Reports.
- NoSQL database systems, such as MongoDB and CouchDB.
- Big data technologies like Hadoop and Spark.
- Cloud services like Amazon AWS and Microsoft Azure The Software Development Life Cycle (SDLC), specifically Scrum and Agile methodology.