This job has expired

Database Administrator

JB Consultants
Pune
2 - 10 Years
Not Specified

Job Description

Database Administrator Responsibilities
• 5 to 6 years of testing experience in a product-based company.
• 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
• Should have knowledge in MS SQL DBA (as primary)
• Having a strong knowledge of creating stored procedure, view, trigger, joins
• Experience in developing and maintaining relational structures including backup/recovery and log shipping procedures for SQL Server
• Develop and support MS SQL database replication
• Optimize MS SQL database performance
• Responsible for database integrity, security
• Estimate MS SQL database capacities; develop methods for monitoring database capacity and usage
• Establish mechanisms for data backup/restore of relational databases provide restoration services as needed
• Develop and optimize physical design of MS SQL database systems
• Develop application-specific fault-tolerant distributed database mechanisms
• Knowledge on other database variants like MY SQLis preferred
• Able to prioritize and execute tasks in a high-pressure environment
• Experience working in a team-oriented, collaborative environment
• Good written and oral communication skills
• MSSQL cluster technologies experience is also preferred.
• MSSQL Administrator Certified (Preferred
• A professional database administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users.
Responsibilities
• Build database systems of high availability and quality depending on each end user’s specialised role
• Writing complex query, query optimization, creating store procedure, view, tables etc.
• Design and implement database in accordance to end users information needs and views
• Define users and enable data distribution to the right user, in appropriate format and in a timely manner
• Use high-speed transaction recovery techniques and backup data
• Minimise database downtime and manage parameters to provide fast query responses
• 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
• Requirements
• 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
• Previous experience with DBA case tools (frontend/backend) and third party tools
• Familiarity with programming languages API
• Problem solving skills and ability to think algorithmically
• BS degree in a computer discipline or relevant certification

• establish the needs of users and monitoring user access and security
• monitor performance and manage parameters in order to provide fast responses to front-end users
• map out the conceptual design for a planned database
• consider both back-end organisation of data and front-end accessibility for end-users
• refine the logical design so that it can be translated into a specific data model
• further refining the physical design to meet system storage requirements
• install and test new versions of the database management system (DBMS)
• maintain data standards, including adherence to the Data Protection Act
• write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
• control access permissions and privileges
• develop, manage and test back-up and recovery plans
• ensure that storage and archiving procedures are functioning correctly
• carry out capacity planning
• work closely with IT project managers, database programmers and multimedia programmers
• communicate regularly with technical, applications and operational staff to ensure database integrity and security
• commission and install new applications and customize existing applications in order to make them fit for purpose
• manage the security and disaster recovery aspects of a database.

we are a recruitment agency.

Career Advice to Find Better