5-8 Years exp
Salary max 12 LPA
Remote job
Primary Responsibilities
Your responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users.
Primary responsibilities include:
l Provide guidance and support to Application Developers
l Assist with schema design, code review, SQL query tuning
l Install, tune, implement and upgrade DBMS installations
l Write and deploy SQL patches
l Upgrade and improve application schema and data upgrades
l Process work accurately and in a timely manner
l Pay attention to detail at all times
l Proactively and regularly make recommendations for system improvements.
l Collate, prepare and present statistical information for internal and external use
l monitor performance and manage parameters to provide fast responses to front-end users
l map out the conceptual design for a planned database
l consider both back-end organization of data and front-end accessibility for end-users
l refine the logical design so that it can be translated into a specific data model
l further refining the physical design to meet system storage requirements
l install and test new versions of the database management system (DBMS)
l maintain data standards, including adherence to the Data Protection Act
l write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
l control access permissions and privileges
l develop, manage and test back-up and recovery plans
l ensure that storage and archiving procedures are functioning correctly
l carry out capacity planning
l work closely with IT project managers, database programmers and multimedia programmers
l communicate regularly with technical, applications and operational staff to ensure database integrity and security
l commission and install new applications and customize existing applications in order to make them fit for purpose
l manage the security and disaster recovery aspects of a database.

Required Skills:

Extensive knowledge of:
l excellent problem-solving and analytical skills
l good communication, teamwork and negotiation skills
l familiarity with the main data manipulation languages and the principles of database design
l the ability to work to tight deadlines under pressure
l good organizational skills
l flexibility and adaptability
l the ability to create and maintain strong working relationships with colleagues and customers
l business awareness and understanding of business requirements of IT
l a willingness to keep up to date with developments in new technology
l a commitment to continuing professional development (CPD)
l an understanding of information legislation, such as the Data Protection Act.

Educational Requirements: A pertinent Bachelor's Degree in Computer Science, Math, Engineering, or a related field and 5 to 7 years work experience as a database administrator is required. Managing CMS database and perform optimization consider as addon..



Preferred Skill Set:
l Strong command of SQL and SQL server tools
l Advanced knowledge of database security, backup and recovery, and performance monitoring standards
l Understanding of relational and dimensional data modeling
l PowerShell and Unix shell scripting skills
l Familiarity with SSAS, SSIS, SSRS
l Strong mathematical and statistical knowledge
l Excellent written and verbal communication skills
l Impeccable attention to detail


Industry Work Experience:
Over 6+ years of experience in database administration.Please be prepared to submit a sample of your work that best highlights your skills and satisfies the responsibilities and required skills outlined above.



Personal Qualities: Must be a great team player with a positive attitude, highly organized and needs to take responsibility for user satisfaction with deliverable and possess an impeccable work ethic. A great sense of humor and professional pride will be a significant asset. We have a large ego as an organization but not as individuals, and expect all team members to work together without counterproductive internal competition.