Jr. Database Administrator Mid Level

Job Description

·         Works with vendors, users, applications developers and management to obtain information and develop an understanding of the needs of the organization and to overcome significant operational and/or technical issues or problems.

·         Recommends potential solutions utilizing relational technology

·         Assesses and assigns DBA resources and oversees quality of work produced

·         Recommends reviews and approves the design of physical data models and structures

·         Provides advanced level database management, support and assistance

·         Collaborates with and supports data architects and application developers in the physical design of databases

·         Implements the physical database design and optimization strategies

·         Leads database conversion and migration activities

·         Analyzes, develops and supports disaster recovery plans

·         Provides back-up and recovery procedures as needed for all production and test databases

·         Provides technical consultation to the development staff and other IT organizations or groups

·         Works with management and user committees in setting performance objectives

·         Monitors and tunes database performance to meet performance objectives

·         Manages and monitors storage capacity

·         Evaluates, recommends, and participates in the installation of new storage media

·         Supports operations staff with their production databases

·         Works with programmers to tune data access codes

·         Participates in IT committees to create standards for database utilization

·         Maintains strong vendor relationships to keep apprised of new database products, versions, and releases

·         Escalates intractable problems to the vendor

·         Evaluates, recommends, and installs new versions and releases and new database tools

·         Develops plans to install, maintain, enhance, test and migrates DBMS products and supporting software

·         Coordinates with engineering staff to ensure consistency in planning and implementation efforts

·         Works with application developers and other organizations within the enterprise to evaluate database requirements for application software packages under consideration

·         Provides second level support to the database administrator

·         Responds to and assists with other problem tickets as required

·         Adheres to other defined SOPs as required

·         Performs other duties as assigned Qualifications

Job Specification

·        At least 2years’ experience in an IT organization and/or equivalent application or business experience is preferred

·         Requires strong knowledge of logical design and physical implementation

·         Requires knowledge of enterprise hardware and operations systems

·         Exceptional interpersonal and communication skills with the ability to deal with a diverse range of people, which includes the upper levels of corporate management

·         Self-sufficient, requiring limited supervision over job knowledge, expectations and successful project completion

·         Knows how to use SSMS to monitor jobs, view history, set job notifications, set operators, enable and set Database Mail up

·         Proficient with T-SQL

·         Knows how to use SSMS to monitor access to the server and database

·         Knows how to use SSMS to monitor the database server performance

·         Understands locking , CPU time, wait types , physical reads and logical reads and writes

·         Understands sessions and requests

·         Knows how to use SSMS and T-SQL to verify availability

·         Understands database states and user access options

·         Knows how to operate and configure SQL Server services

·         Understands Windows Clustering

·         Knows T-SQL to troubleshoot errors

·         Knows SSIS to troubleshoot errors

·         Responds promptly to events

·         Knows how to use SSMS and T-SQL to create logins and users, and to grant permissions

·         Understands SQL Server security architecture

·         Knows how to use SSMS and T-SQL to create and modify databases

·         Understands application needs before implementing the database

·         Is familiar with Best Practices for database file structure, security, etc.

·         Is familiar with pre-installation, installation and post-installation steps

·         Is familiar with Best Practices as far as systems databases, security, etc.

·         Knows how to use SSMS and T-SQL to run backups and recoveries

 

Apply Instructions

Interested candidates can email their CV along with a letter of interest to careers@cas.com.np. Please mention the position in the subject line. Only shortlisted candidates will be notified.

This Job is expired. The Company is no longer accepting applications for this position.