Database Developer-Couchbase

POSITION SUMMARY:

Under general direction of the Director of Applications Development or other management level associate, responsible for the development, installation, and maintenance of systems software.

PRIMARY DUTIES AND RESPONSIBILITIES:

1. Designs, develops, and implements complex SQL Server databases and solutions to meet business requirements.
2. Implements best practices for database schema design, normalization, denormalization, and data partitioning where necessary.
3. Writes and optimizes T-SQL queries, stored procedures, functions, and triggers for efficient data retrieval and manipulation.
4. Analyzes database performance metrics and query execution plans to optimize database performance.
5. Implements indexing strategies, query optimization techniques, and caching mechanisms to enhance database performance.
6. Designs and develops Couchbase data models, document structures, and indexes to support efficient data storage and retrieval.
7. Implements N1QL queries, views, and indexes to optimize data access and manipulation in Couchbase databases.
8. Develops and maintains application design, program specification documents, and proprietary applications.
9. Interacts with user management regarding project status and user requirements to promote an environment with improved productivity and satisfaction