POSITION PURPOSE

The Database Admin/ Backend Developer is responsible for ensuring that the front-end designs work with the back-end functionality and security of the application's data, including setting up security protocols, preventing cyber- attacks, and monitoring the database for errors. This role will be designing stable and reliable databases, according to our company’s needs. You will be responsible for developing, testing, improving and maintaining new and existing databases to help users retrieve data effectively.

As part of our IT team, you will work closely with front-end developers, define and communicate technical and design requirements, and provide training and support to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude. Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis.

Key duties include:
Configuration and Customization Microsoft Dynamics 365 (FO & CRM)
Integration with other system (Understanding Azure Communication Service and Azure API Management)
Design stable, reliable and effective databases
Modify databases according to requests and perform tests
Solve database usage issues and malfunctions.
Attention to detail, a mastery of organization and process optimization, the ability to quickly understand and respond to local regulatory requirements and to work with multiple stakeholders is crucial to the success of this role.

JOB ESPECIFICATIONS
Configuration and Customization Microsoft Dynamics 365(40%)
•    Responsible for the development, and on-going support of custom applications and objects within Microsoft Dynamics CRM        
•    Customize Microsoft Dynamics CRM Entities, create multiple forms (security based) on entities, add custom JavaScript on form events and add web resources, navigation links to achieve the business requirements.
•    Resolve technical issues of varying complexity through an in-depth understanding of CRM/.Net and engaging appropriate resources.
•    Design and customize CRM forms, Ribbons, Sitemap, Workflows and Actions.
•    Customize Workflows and Plugins for automated processes based on the requirements from different departments to increase visibility and efficiency.
•    Develop and test MS Dynamics CRM client-side programming using (JavaScript / HTML) using the Microsoft Dynamics CRM Customization SDK Tool Kit
•    Technologies: C#.NET, JavaScript, Html, Team Foundation Server, Visual Studio 2015/2017, Ribbon workbench Tool and SDK Toolkit.
•    Perform CRM application testing of configurations and customizations
•    Extend capability of CRM through creation of new entities, forms, workflows, and reports
•    Perform data migration activities.

Database Administration (40%)
•    Building database systems of high availability and quality depending on each end user’s specialized role
•    Designing and implementing databases in accordance to end users information needs and views
•    Defining users and enabling data distribution to the right user, in appropriate format and in a timely manner
•    Use high-speed transaction recovery techniques and backup data
•    Administer, maintain, and secure Azure SQL databases, ensuring the integrity and availability of the company database.
•    Collaborate with development teams to optimize database performance and contribute to the architecture of future database states.
•    Minimize database downtime and manage parameters to provide fast query responses
•    Design, implement, and maintain database structures, ensuring  data  integrity,  security,  and  optimal performance.
•    API integration will be a core aspect of your responsibilities, requiring you to collaborate with cross- functional teams to enhance our systems' capabilities.
•    Provide proactive and reactive data management support and training to users
•    Determine, enforce and document database policies, procedures and standards
•    Perform tests and evaluations regularly to ensure data security, privacy and integrity
•    Monitor database performance, implement changes and apply new patches and versions when required
•    Provide guidance and support to development teams on best practices for database usage, optimization, and deployment strategies.
•    Stay updated with the latest technologies and trends in database administration and security to recommend improvements for the database environment
•    Tuning databases to improve response times of queries.
•    Creation of jobs, stored procedures, and other database activities as needed.

Understanding Business and User Requirement (20%)

•    Analyze and document business processes and Develop solutions by working with business analysts and/or users to perform technical analysis options, and estimates.
•    Work collaboratively with Seattle IT teams (Systems Engineer, DBA, QA, etc.) to build, test, deploy, and maintain software using custom and industry common practices throughout multiple environments (e.g. Sandbox/DEV/QA/UAT/PROD).
•    Respond to incidents and events with methodical approaches to assess and troubleshoot all types of production (performance, access, accuracy, etc.).
•    Reliably subdivide large tasks into appropriately sized work-in-progress periods, provide accurate estimates of those work packages, summarize the work into a trustworthy schedule, and monitor the work through completion.
•    Control of database security systems and how users interact with the data.
•    Documentation of database processes.

ESSENTIAL QUALIFICATIONS AND EXPERIENCE

•    Bachelor's degree (BSc) in Information Technology, Mathematics, Computer Science, or a relevant field or additional qualifying experience
•    Mínimum of 3 years of experience in Microsoft Dynamics CRM/Sales development (experience with AX or Finance & Operations is a plus but must include CRM).
•    2+ years of proven experience as a Database Administrator, with a strong focus on Azure databases.
•    Deep understanding of database structure principles, SQL, and Azure cloud services.
•    In-depth understanding of data management (e.g. backup, permissions, recovery, security and monitoring)
•    Proficiency in customization and configuration of Microsoft Dynamics 365 or Sales Modules
•    Strong knowledge of .NET, JavaScript and other related technologies.
•    Experience with Dynamics 365 integrations and API development
•    Familiarity with Agile development methodologies.
•    Excellent analytical and organization skills
•    An ability to understand front-end users requirements and a problem-solving attitude
•    Excellent verbal and written communication skills In-depth knowledge of Microsoft Dynamics 365 application configuration, including customizing.
•    Dynamics using plug-ins and custom workflows
•    Experience with Microsoft Dynamics application architecture and design

SKILLS AND ATTRIBUTES

•    Mid-to Senior level Microsoft Dynamics Developer focusing on Microsoft Dynamics 365 CRM or Sales modules
•    Customizing and configuring CRM or Sales solutions within Dynamics 365, including experience in integration and API development
•    Experience with Dynamics AX or Finance and Operations (F&O)
•    Proven working experience as a Database Administrator
•    Hands-on experience with database standards and end user applications
•    Excellent knowledge of data backup, recovery, security, integrity and SQL
•    Familiarity with database design, documentation and coding
•    Familiarity with programming languages API
•    Problem solving skills and ability to think algorithmically
•    BS degree in a computer discipline or relevant certification
•    Good time-management skills to meet project deadlines.
•    Willing to travel on business when required.
•    Personally aligned with company purpose and values.