| Database Manager & Administrator 4 || In person Interview to New Jersey at Remote, Remote, USA |
| Email: [email protected] |
| From: priya, Anveta INC [email protected] Reply to: [email protected] Hello Team, Only Local to New Jersey NJDHS-DFD Database Manager/Administrator 4 (717408) Location : Hamilton Township, NJ 08619 -( In Person Only )-( Hybrid ) Client : State of New Jersey Duration: 6+ Months Note: Hybrid Role 3 Days Onsite and 2 Days Remote Please note that this is a hybrid role that requires an in person interview. Job Description Responsibilities: Design, implement and support data models, databases, and DW solutions to meet the long-term goals for the DHS/DFD office. Develop and implement OLTP schemas, comprehensive testing plans for validating data transformation and integration, develop key metrics to ensure integrity on data architecture. Responsible to take the ownership for their assigned tasks and work independently and deliver results in an iterative approach adhering to the sprint deadlines. Must work collaboratively with the team of developers, Technical Lead, Architect, Business SMEs, and Project Managers. Recognizes problems and responds, systematically gathers information, sorts through complex issues, seeks input from others, addresses root cause of issues, makes timely decisions, can make difficult decisions, uses consensus when possible, communicates decisions to others, and rapidly adapts to change. Required Skills: Database modeling, architecture design, development, backup & recovery, and administration. SQL Server scripting and programming in various platforms, detailed analysis and design. SQL Server is required (Oracle and PL/SQL is a plus). Experience in rapidly building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes, and other database components to support the existing & new development features in an agile environment. SQL development (SSMS), Microsoft BI Stack (SSIS, SSAS). Prior experience using various reports including SSRS (required) for report development. Familiarity with developing Restful APIs for database layer, and web application architecture. Strong expertise in analyzing and converting hierarchical data into relational data, including descriptions and diagrams. Nice to Have: Knowledge/Experience in developing, hosting & managing databases on AWS RDS. Knowledge/Experience implementing database designs, transactions for microservice architecture. Experience in application modernization and migrating legacy platforms data models (Mainframes or similar). Experience with GitHub, JIRA, .Net Core, EF core, Dapper, DataLake, Redshift, Docker/Kubernetes container services. Minimum Requirements: 7+ years of Database design, SQL/TSQL development, SSMS, SSIS, SSAS & SSRS experience. 1-2+ years on AWS RDS. Bachelors degree in Computer science or in a related field. Skill Required / Desired Amount of Experience Database modeling, architecture design, development, backup & recovery, and administration. Required 5 Years SQL Server scripting and programming in various platforms, detailed analysis and design. Required 5 Years Experience in rapidly building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes. Required 5 Years SQL development (SSMS), Microsoft Power BI Stack (SSIS, SSAS, SSRS) Required 5 Years Fix any issues related to database performance and provide corrective measures. Required 5 Years Familiarity with developing Restful APIs for database layer, and web application architecture. Required 5 Years Create, modify, and optimize SQL Server Agent jobs and maintenance plans. Required 5 Years Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner. Required 5 Years Strong expertise in analyzing and converting hierarchical data into relational data, including descriptions and diagrams. Required 5 Years Scripting and programming under Oracle using PL/SQL Nice to have 1 Years Knowledge/Experience in developing, hosting & managing databases on AWS RDS. Nice to have 1 Years Knowledge/Experience implementing database designs, transactions for microservice architecture. Nice to have 1 Years Experience in application modernization and migrating legacy platforms data models (Mainframes or similar). Nice to have 1 Years Experience with GitHub, JIRA, .Net Core, EF core, Dapper, DataLake, Redshift, Docker/Kubernetes container services. Nice to have 1 Years Keywords: business intelligence procedural language New Jersey |
| [email protected] View all |
| Thu Dec 07 21:38:00 UTC 2023 |