Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Provides technical support for the administration, development, implementation, business users and maintenance of database applications. Creating and running standard filtered and ad-hoc report requests. Analyze and document database applications.

This is a Data Administrator, not a DBA. Primary roles will be to administratively support database access requests and connectivity to databases along with reporting requests. Do not submit technical DBAs to this role.

Administer and support database application business solutions. This position is responsible for the support, monitoring, provisioning, development and maintenance of MS Access, SQL and Microsoft Dynamics 365 database applications. The ideal candidate will have sound knowledge in database Best Practices, entities/tables, configurations, portal administration, user administration, query / report development, Reporting / Advanced Find, Views, Dashboards, and developing custom solutions.

The person should be an expert in working with data and automation utilizing configurations first and only custom code when absolutely required. Strong background in the planning, designing, installing, configuring, and customizing of relational data modeling solutions that are innovative, while observing best practices in regards to supported extensions of the platform.

Work with business users to help them improve their processes and systems. Assess processes, determine requirements and deliver recommendations, design documentation and reports. Engage with business users to understand how changes to process, services and software can improve efficiencies and add value. Conduct research and analysis in order to come up with solutions to business problems and help to introduce these recommendations. Must articulate those ideas but also balance them against what's technologically feasible and functionally reasonable.

EXPERIENCE:

Ability to communicate effectively in both spoken and written English.

Experience as a database application administrator.
Experience with Microsoft SQL Server 2016+.
Experience with creating T-SQL Queries, Stored Procedures, Reports, Relationships, Data Mapping, Data Exports and Data Imports.
SSRS development for standard parameter driven and ad-hoc custom reporting.
Troubleshoot database application errors and performance related issues.
Experience administering database applications in cloud environments (Azure or AWS) including SaaS and IaaS.
Review current system data structure, and model new data structure based on current operational requirements.
Evaluate and map existing data structure fields for legacy data migration.

Highly-desired, knowledge of MS Dynamics 2016/365 CRM, and the O365 platform as it pertains to feature sets that integrate with Dynamics CRM solutions, including SharePoint.
Highly desired, knowledge of and ability to in MS Dynamics 365 configure business units, security groups, teams, roles and web roles.

Must be flexible and willing to learn, administer and support new technologies and also legacy systems.
The ability to convey knowledge to both developers and business users to balance the use of native (OOB) features and the appropriate use of custom development.
Creating and maintaining task, knowledge transfer and FAQ documentation.
Document as-is processes, recommendations, designs and implementations for improvements.
Document and prioritize business user requests
Works with other technical and project groups to ensure that software application requirements are identified at an early stage, ensuring that new build requirements or expansions are captured, and plans produced for any upgrades/expansions and new build.
Maintain the documentation, processes, guidelines, and procedures of the project management methodology including infrastructure procedures and protocols for the smooth operation of the day-to-day business.
Partners with business, technical, clinical, quality and utilization teams to complete project management activities to ensure successful completion of project needs.

RELEVANT WORK EXPERIENCE:
6 to 8+ yrs.

EDUCATION:
4 year+ degree preferred

This position is 5 days a week physically in the office at 120 S. Stockton Street Trenton NJ. This may move to 2 days remote after training is completed and everyone is up to speed. After COVID restrictions are lifted this may move back to full time in the office.

Required/Desired Skills