- Design, create, and implement database systems based on the requirements.
- Design databases and ensuring their stability, reliability, and performance.
- Develop database schemas, tables, and data cubes.
- Create complex functions, scripts, stored procedures, and triggers to support application development. In depth knowledge of TSQL is must.
- Fix any issues related to database performance and provide corrective measures.
- Analyze existing SQL queries or Suggest new queries for performance improvements. Improve application performances.
- Develop procedures and scripts for data migration.
- Ensure the data quality and integrity in databases.
- Test databases and perform bug fixes.
- Memory management for database systems.
- Develop best practices for database design and development activities.
- Prepare documentations for database applications.
- Managing Database schema, data scripts and upgrade scripts in source control.
Knowledge, Skills, and Abilities:
- Deep scripting/programming skills especially in T-SQL and PowerShell (PowerShell is a plus).
- Deep knowledge of Microsoft SQL Server and SQL Azure database design and development.
- Innovative thinker with a commitment to improve processes and methodologies.
- Strong written and verbal communications skills.
- Create/Maintain database schema, data scripts and upgrade scripts in source control.
- Experience with RIM model-based database is a plus.
- Knowledge in OLAP database designs is a plus.
Job Requirements:
- Minimum 3 to 5 years Microsoft SQL Server database development experience.
- Prior exposure to software development processes and/or methodologies.