Description
This is a development position for a .Database modeler/developer
PLEASE 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.
1Design and develop database systems that are efficient, scalable, and secure. Required to determine the appropriate database architecture, data storage, and indexing techniques. Hands-on experience in building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexesRequired
2Work closely with software developers, system administrators to ensure that databases meet performance and scalability requirements. Analyzing an organization's data needs, identifying the most appropriate database systems, designing and implementing database structures, and ensuring data security and integrity.Required
3 Analyst should have experience in Back-end data integration and architecture including dimensional data modeling(partitioning), database design, data warehousing, ETL development, and performance tuning with the Reporting tool Microsoft Power BI Stack experienceRequired
4Experience in DB migration project (Oracle to SQL) with Understanding in designing and maintaining High Availability (HA) and Disaster Recovery (DR) options for SQL ServerRequired
5Design the DB deployment strategy, DB maintenance across the environmentsRequired
6Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the applicationRequired
7Focus on designing and maintaining data warehouses, with large-scale repositories of data used for analysis and reporting. Work closely with data analysts and business intelligence professionals to design data models and create efficient queries for extracting data.Required
8Associate should have experience in designing and implementing solutions for managing data in the cloud. Experience in working on AWS RDS will be an advantageNice to have
9Ensuring data security and integrity, associate should be able to ensure that the data is secure and protected from unauthorized access or modification. Able to implement security protocols such as encryption, access controls, and data backup and recovery procedures. Also ensure that the data is accurate, consistent, and up-to-date by implementing data quality and data validation rules.Nice to have
10Automate regular processes, track issues, and document changesNice to have
Required/Desired Skills
| Skill | Required /Desired | Amount of required exprience in yrs | Candidate response |
|---|---|---|---|
| Ensure databases are production-ready with rigorous testing, performance validation, and best practices for high availability and disaster recovery | Required | 5 | Years |
| Work independently, with minimal support on the DB issues pertaining to development of the Stored Procedures, Functions and DB maintenance. | Required | 5 | Years |
| Design and 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 |
| Designing schema, access patterns, locking strategy, SQL development, and tuning. Should be able to develop these independently. | Required | 5 | Years |
| Design DB deployment strategy across the environments, experience with version control systems and CI/CD pipelines for DB changes | Required | 5 | Years |
This is a development position for a .Database modeler/developer
PLEASE 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.
1Design and develop database systems that are efficient, scalable, and secure. Required to determine the appropriate database architecture, data storage, and indexing techniques. Hands-on experience in building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexesRequired
2Work closely with software developers, system administrators to ensure that databases meet performance and scalability requirements. Analyzing an organization's data needs, identifying the most appropriate database systems, designing and implementing database structures, and ensuring data security and integrity.Required
3 Analyst should have experience in Back-end data integration and architecture including dimensional data modeling(partitioning), database design, data warehousing, ETL development, and performance tuning with the Reporting tool Microsoft Power BI Stack experienceRequired
4Experience in DB migration project (Oracle to SQL) with Understanding in designing and maintaining High Availability (HA) and Disaster Recovery (DR) options for SQL ServerRequired
5Design the DB deployment strategy, DB maintenance across the environmentsRequired
6Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the applicationRequired
7Focus on designing and maintaining data warehouses, with large-scale repositories of data used for analysis and reporting. Work closely with data analysts and business intelligence professionals to design data models and create efficient queries for extracting data.Required
8Associate should have experience in designing and implementing solutions for managing data in the cloud. Experience in working on AWS RDS will be an advantageNice to have
9Ensuring data security and integrity, associate should be able to ensure that the data is secure and protected from unauthorized access or modification. Able to implement security protocols such as encryption, access controls, and data backup and recovery procedures. Also ensure that the data is accurate, consistent, and up-to-date by implementing data quality and data validation rules.Nice to have
10Automate regular processes, track issues, and document changesNice to have
Required/Desired Skills
| Skill | Required /Desired | Amount of required exprience in yrs | Candidate response |
|---|---|---|---|
| Ensure databases are production-ready with rigorous testing, performance validation, and best practices for high availability and disaster recovery | Required | 5 | Years |
| Work independently, with minimal support on the DB issues pertaining to development of the Stored Procedures, Functions and DB maintenance. | Required | 5 | Years |
| Design and 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 |
| Designing schema, access patterns, locking strategy, SQL development, and tuning. Should be able to develop these independently. | Required | 5 | Years |
| Design DB deployment strategy across the environments, experience with version control systems and CI/CD pipelines for DB changes | Required | 5 | Years |
Key Skills
Education
Any Gradute
- Posted On: 13-Jun-2024
- Experience: 5+ years of experience
- Openings: 1
- Category: Database Architect
- Tenure: Contract - Corp-to-Corp Position