What are the responsibilities and job description for the Database Architect position at Sunrise Systems, Inc.?
Job Title: Database Architect Job ID: 26-01282 Location: Hamilton, NJ(Hybrid - 3 days onsite 2 remote) Duration: 03 months of contract with Possibility of extension.
Designs, develops, and implements highly-complex, reliable, and scalable databases to meet the organization's objectives and requirements. This is a development position for a Database modeler/developer.
Designs, develops, and implements highly-complex, reliable, and scalable databases to meet the organization's objectives and requirements. This is a development position for a Database modeler/developer.
- The Database Architect is responsible for designing, developing, and implementing 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.
***PLEASE INCLUDE JOB DETAILS, TASKS, AND RESPONSIBILITIES SPECIFIC TO THIS REQUISITION***
LEASE note: This position will continue for an extended period of time well beyond the end date.
Only submit candidates that will interview round one in person only.
Database Architecture & Design (30%)
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.
***PLEASE INCLUDE JOB DETAILS, TASKS, AND RESPONSIBILITIES SPECIFIC TO THIS REQUISITION***
LEASE note: This position will continue for an extended period of time well beyond the end date.
Only submit candidates that will interview round one in person only.
Database Architecture & Design (30%)
- Design target SQL Server database architecture
- 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%)
- Develop comprehensive data migration strategy
- Create ETL processes for migrating huge data
- Design and implement data validation procedures
- Ensure zero data loss during migration
- Create data mapping documentation
- 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
- Optimize queries for sub-second response times
- Tune stored procedures and functions
- Implement query optimization techniques
- Monitor and resolve performance bottlenecks
- Design caching strategies
- Optimize batch processing (6-hour window to 4-hour target)
- Implement table partitioning for large tables
- Configure SQL Server for optimal performance
- Conduct performance testing and benchmarking
Database Administration (15%)
- Install, configure, and maintain SQL Server instances
- Implement security policies and access controls
- Manage database users, roles, and permissions
- Monitor database health and performance
- Implement backup and recovery procedures
- Perform database maintenance (index rebuilds, statistics updates)
- Manage database growth and capacity planning
- Implement monitoring and alerting
- Troubleshoot database issues
- Coordinate with cloud infrastructure team
High Availability & Disaster Recovery (10%)
- Implement SQL Server Always On Availability Groups
- Configure database replication
- Design and test disaster recovery procedures
- Achieve RPO <1 hour, RTO <1 hour (vs. 24 hrs/8 hrs current)
- Implement automated failover mechanisms
- Conduct DR testing and validation
- Document DR procedures and runbooks
- Coordinate with cloud team on multi-region deployment
Required Qualifications
Technical Skills (Must Have)
SQL Server Expertise
Technical Skills (Must Have)
SQL Server Expertise
- 8 years of SQL Server administration experience
- Expert knowledge of SQL Server 2019/2022
- Advanced T-SQL programming (stored procedures, functions, triggers, views)
- Query optimization and execution plan analysis
- Index design and optimization
- Database design and normalization (1NF through 5NF)
- SQL Server security and compliance
- Backup and recovery strategies
- SQL Server Agent and job scheduling
- Database maintenance plans
High Availability & Disaster Recovery
- SQL Server Always On Availability Groups
- Database mirroring and replication
- Log shipping
- Failover clustering
- Multi-region deployment strategies
- Backup and restore strategies
- Point-in-time recovery
- Disaster recovery planning and testing
Performance Tuning
- Query performance tuning and optimization
- Index tuning and maintenance
- Execution plan analysis
- Wait statistics analysis
- Blocking and deadlock resolution
- Resource Governor configuration
- Memory and CPU optimization
- I/O optimization
- Performance monitoring tools (SQL Profiler, Extended Events, DMVs)
Cloud Database Services
- AWS RDS for SQL Server (3 years)
- Cloud database security and compliance
- Cloud backup and recovery
- Cloud monitoring and alerting
- Cost optimization strategies
Data Migration
- Large-scale data migration experience (500GB )
- Conversion scripts experience
- ETL tools and processes (SSIS, Azure Data Factory, AWS DMS)
- Data validation and quality assurance
- Legacy database migration experience
- Network database to relational conversion
- Data mapping and transformation
- Migration automation and scripting
Scripting & Automation
- PowerShell scripting for automation
- T-SQL scripting
- Source code management, GIHUB
- CI/CD for database deployments
- Automated testing frameworks
Professional Experience (Must Have)
- 10 years of database administration experience
- 8 years of SQL Server administration
- 3 years of cloud database experience (Azure SQL or AWS RDS)
- Experience with large-scale data migrations (500GB databases)
- Experience with mission-critical systems (99.9% uptime)
- Led or participated in database modernization projects
- Experience with high-transaction environments (50K transactions/day)
- Experience with Agile/Scrum methodologies.
Skill Matrix:
| Skill | Required / Desired | Amount | of Experience |
| Ensure databases are production- Required ready with rigorous testing, performance validation, and best practices for high availability and disaster | Required | 5 | Years |
| Work independently, with minimal Required support on the DB issues pertaining to development of the Stored Procedures, Functions and DB maintenance | Required | 5 | Years |
| Designand develop database systems that are efficient, scalable, and secure.Hands-on experience in building new relational data models, tables, views | Required | 5 | Years |
| Design the DB deployment strategy, DB maintenance of all environments | Required | 5 | Years |
| DB migration project (Oracle to SQLSerrver) with understanding in designing and maintaining High Availability (HA) and Disaster Recovery (DR) options | Required | 5 | Years |
| Back-end data integration and architecture including dimensional data modeling(partitioning), database design, data warehousing, ETL development | Required | 5 | Years |
| Knowledge/Experience in developing, hosting & managing databases on AWS RDS. | Required | 5 | Years |
| Implements security protocols such as encryption, access controls, and data backup and recovery procedures. | Required | 5 | Years |
| Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the application | Required | 5 | Years |
| Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the application | Required | 5 | Years |
| Design DB deployment strategy across the environments, experience with version control systems and Cl/CD pipelines for DB changes | Required | 5 | Years |
| Source code maintenance, working experience in GITHUB | Required | 5 | Years |
Compensation:
The hourly rate for this position is between $56.00-$62.00 per hour.
Factors which may affect starting pay within this range may include [geography/market, skills, education, experience and other qualifications of the successful candidate].
Benefits:
Sunrise offers ACA compliant medical coverage/dental insurance/vision insurance to all employees. We also offer Sick time benefits as required per State regulations.
The hourly rate for this position is between $56.00-$62.00 per hour.
Factors which may affect starting pay within this range may include [geography/market, skills, education, experience and other qualifications of the successful candidate].
Benefits:
Sunrise offers ACA compliant medical coverage/dental insurance/vision insurance to all employees. We also offer Sick time benefits as required per State regulations.
Salary : $56 - $62