Job
Description
At YASH, were a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future. We are looking forward to hire a MS SQL Database Administrator. JOB RESPONSIBILITIES Responsible for primary support of third-party systems including DBA support of production, test and development environments and reporting processes. Administer lead activity for database security, database backups/recovery and perform database monitoring, analysis and optimization of all database environments. Assist end user/s with reporting requirements, documentation for queries, reporting and database design. Write complex queries, functions, stored procedures and triggers. Develop and document technical specifications for third party systems implementation and reporting. Design, plan and implement assigned database environments. Properly size and configure databases and their associated tables. Provide production support in a 24/7 environment. Coordinate, administer, and perform installation, configuration, troubleshooting and maintenance of assigned database environments. Create and maintain database standards, policies, and procedures, change management standards and policies and ensuring consistency between these and the environments. Formulate recommendation improvements in these areas. Responsible for the implementation and support of security measures and products, including activities such as database hardening, vulnerability assessment and patch management. Assist in the troubleshooting and resolution of complicated issues within the applications, software/hardware in database environments. Evaluate, recommend, and use software tools to monitor and manage database health and performance. Plan, coordinate, configure and implement assigned database application patches and upgrades. Define and maintain capacity plans, disaster recovery plans and facilities for the database environments. Train and mentor other team members through knowledge transfer. Monitor database environments for proper operation within established performance and availability expectations. Work with technical analyst to properly size and configure servers for databases and application servers. Responsible for advanced configuration of database environments for database level backup/restore technologies and troubleshooting configuration problems. Maintain current knowledge of trends and future direction in technology as it relates to area of responsibility. Assist with justifications for operating and capital budgets. Prepare and present technical reports and feasibility studies. Develop strategic technical implementation plans and work plans for technical teams. Regular time and attendance. Other duties as assigned. Job Requirements At least 5 years experience as a database administrator in a production environment is required. Disaster Recovery/ Business Continuity plans and implementation experience using a remote environment is required. Previous experience working in a team environment is required. Bachelors degree from an accredited institution in Computer Science or related area is required, OR significant work-related experience in all job requirements for this position may be considered in lieu of degree requirement. Computer skills required: MS SQL 2008+, SSRS, SSIS, VSDT Proficient with Microsoft Office Suite to include Word, Excel, and Outlook Outstanding organizational and time management skills Excellent communication skills and the ability to communicate with tact and diplomacy Attention to detail and the ability to concentrate for extended periods of time. Excellent time and attendance Ability to work in a team environment Self-motivation
