Under supervision, with latitude for independent action and the exercise of independent judgment, the Database Administrator (SQL Server Database/Microsoft Dynamics Middle Tier) is responsible for managing and maintaining all Microsoft SQL Server and Microsoft Dynamics Server environments. The candidate specific duties will include:
* Plan, design, install, configure, secure, maintain, and support all versions of Microsoft SQL DB Servers, Microsoft Dynamics on Windows OS environments
* Analyze, monitor the resource utilization, and tune the performance of the SQL, Dynamics Servers and associated components; monitor thread usage, CPU & memory usage
* Analyze the log files, thread dumps, exception stack traces
* Experience with MSSQL High Availability, Always On and Replication.
* Configure and deploy HTTPS/SSL certificates to setup secure encrypted access to the websites
* Configure Single sign on for application access
* Develop, validate, and implement an overall strategy to patch server environments including security updates on a regular schedule
* Ensure that all changes to the environment adheres to established Change Management policies and procedures
* Perform regular SQL Server backup and restore/recover when needed
* Perform periodic disaster recovery test for the database/application server environments and maintain disaster recovery documentation and procedures in support of these systems
* Collaborate with application developers, database administrators and system administrators for configuration and integration of database and application components
* Evaluate new systems and applications requirements for resource planning
* Setup and monitor the scheduled batch jobs
* Setup and monitor system alerts to provide 24x7 support and high availability
* Liaise with Microsoft , and other vendors to troubleshoot technical issues
* Follow communications protocol for system failures/outages and file incident reports
* Respond to Service Desk tickets for technical support ensuring timely follow up and resolution
* Prepare system configurations and management/support documentation and provide training and knowledge transfer to other team members as needed
* Create and maintain infrastructure/Architecture diagrams
* Available to work after hours and weekends as needed
PREFERRED SKILLS:
Preferably 6-8 years' experience as database administrator managing a large scale of Microsoft SQL servers in windows OS environment; Core knowledge to install, configure, manage, monitor, & troubleshoot: Microsoft SQL Servers, Microsoft Dynamics Server, and Other third Party windows products, experience with ETL tool set, preferably Microsoft SSIS, Certification in MSSQL Server Database Administration preferred, Experience in IIS, .Net, Visual Basic, Cold Fusion , SSL/HTTPS,Windows Server environment, and Disaster Recovery; Experience in code deployment using change management process for Microsoft Dynamics; Knowledge of approaches, tools and techniques for recognizing and resolving technical (hardware, software, application) problems; Strong interpersonal skills, problem solving skills, customer service and interpersonal skills; Ability to multitask and perform in a high-paced/high-pressure environment; Ability to work independently or within a group to solve complex problems; Ability to communicate with different levels of the organization; Strong team player with service-oriented attitude and customer focus.