Design, develop, and implement infrastructure to provide highly‑complex, reliable, and scalable databases to meet the organization’s objectives and requirements.
Familiar with a variety of the database technologies, concepts, methodologies, practices, and procedures and relies on experience and judgment to plan and accomplish goals.
Performs a variety of complicated tasks with minimal or no direct supervision.
Assists in defining system and application architecture and provides vision, problem anticipation, and problem‑solving ability to an organization.
Consults with the client to define needs or issues, conduct research, perform studies and surveys to obtain data, and analyze problems to advise on or recommend solutions, utilizing knowledge of theory, principles, or technology of specific discipline or field of specialization.
PREFERRED QUALIFICATIONS
Extensive knowledge of specific database systems and capable of hands‑on work in all phases of database design and management.
Experience in various technologies and roles including database systems of any type and size.
Experience in working on database conversion.
Design normalized schemas across multiple databases.
Design data partitioning strategy for large tables (50M+ records).
Create database security architecture.
Design audit trail and history tracking mechanisms.
Establish backup and recovery architecture.
Design high availability and disaster recovery solutions.
Data Migration (25%)
Design and implement data validation procedures.
Develop rollback and recovery procedures.
Perform data quality assessment and cleansing.
Coordinate with developers on core integration with the business logic.
Validate referential integrity and relationships.
Create migration scripts and automation.
Performance Optimization (20%)
Design indexing strategy for optimal performance.
Tune stored procedures and functions.
Monitor and resolve performance bottlenecks.
Design caching strategies.
Optimize batch processing (6‑hour window to 4‑hour target).
Implement table partitioning for large tables.
Conduct performance testing and benchmarking.
Database Administration (15%)
Install, configure, and maintain SQL Server instances.