Sr. Database Developer
Share
Job Location:
Trenton, NJ - USA
Monthly Salary:
Not Disclosed
Posted on:
13 hours ago
Vacancies:
1 Vacancy
Job Summary
- Look for Database developer with Solid SQL server exp.
- Should be local.
- Ready to go in person interview.
Must be 12 year of exp.
Sr. Database Developer
EWD
Hybrid at Trenton NJ - 3 days onsite 2 days remote
Local to NJ only & In person Interview must
Rate : $65/hr on C2C
USC/GC/GC-EAD/H4-EAD Only
LinkedIn is must Need at-least 12 years of candidate
Description:
The Database Developer is responsible for designing developing and implementing infrastructure to provide highly-complex reliable and scalable databases to meet the organizations 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***
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 &
