Albany, New York
Duties
- Performing database and platform administration tasks for Center for Health Data Innovation (CHDI) systems and tools, including cloud analytics environment and data quality and matching tools.
- Research and provide input on technical designs for database architecture in environments.
- Implement design to meet highly complex business needs and technical design document, and support design, creation and testing.
- Establish processes for and manage database access and permissions.
- Review and manage database security, integrity, and backups.
- Monitor database performance, including incident and problem management.
- Monitor database usage and provide reports to technical manager and team to inform design changes.
- Create appropriate documentation in work assignments such as program code and technical documentation.
- Assist end users with database activities such as table creation and indexing related to data loading, view creation, and other database functions.
- Troubleshoot complex end user technical issues, identify problems and leading solutions.
Mandatory Requirements
- Experience (10+ Years)
- Uses specialized software to store and organize data, which may include capacity planning, installation, configuration, database design, migration, performance monitoring, security and troubleshooting, as well as backup and data recovery.
Requirements
- This is an 100% Onsite.
- 84 months of experience in database/schema architecture, SQL coding, testing, maintenance and debugging skills.
- 84 months creating, testing, maintaining secure databases using security APIs, transport and message layer security, encryption, and decryption algorithms for data security, PL/SQL, Normalization, Database Optimization.
- 48 months of monitoring database usage and performance, leading incident and problem management, documenting and reporting issues and leading solutions
- 48 Months establishing procedures for and managing database access and permissions.
- 48 months experience creating cloud native database design that can include aspects such as containerization, API-first, serverless and microservices architecture.
- 48 months experience in a cloud environment, including knowledge on cloud/hybrid infrastructure including AWS or GCP.
- Résumé.