Send me more jobs like this

Database Administrator

Keywords / Skills : Database Administrator

4 - 7 years
Posted: 2019-01-02

Industry
IT/ Computers - Software
Function
IT
Role
Database Administrator (DBA)
Posted On
2nd Jan 2019
Job Ref code
8a7887a8670aebc40167
598a062446f2
Job Description

Techwave Consulting India PVT Ltd
SQL DBA

Job Description

The Database Administrator will be responsible for the implementation, configuration, maintenance, and performance of critical Server RDBMS systems running on various SQL versions like MySQL, Microsoft SQL, Oracle, DB2. Must ensure the availability and consistent performance of our corporate applications related databases. Monitor the metrics from the DB’s and take a necessary action as may be required.
Responsibilities

The candidate will be responsible for the deployment, development and maintenance of the SQL Server, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. The DBA should be able to support any enterprise application suite of program management tools. Must be capable of working independently and collaboratively. Should be possessing solid technical skills, as well as excellent interpersonal and communication skills.
  • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
  • Refine and automate regular processes, track issues, and document changes
  • Assist developers with complex query tuning and schema refinement.
  • Provide 24x7 support for critical production systems.
  • Perform scheduled maintenance and support release deployment activities after hours.
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Skills

Should have strong multitasking skills with an ability to identify even minor defect loop holes and plug them. Should be able to think ahead of time and evolve strategies to protect infrastructure.
  • Experience with performing as a DBA for SQL servers, including performing installations and scheduling and managing backup, recovery, tuning, and other maintenance activities.
  • Experience with troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues.
  • Experience with performance tuning, query optimization, Performance Monitor, SQL Profiler, and equivalent monitoring and troubleshooting tools
  • Knowledge of indexes, index management, integrity checks, configuration, and patching and how statistics work, how indexes are stored, and how they can be created and managed effectively
  • Knowledge of SQL server tools, including Profiler, DTA, SSMS, SAC, SSCM, Perfmon, DMVs, and system specs
  • Knowledge of SQL, stored procedures, and best practices for schemas and ETIs
  • Ability to detect and troubleshoot SQL Server CPU, memory, I/O, disk space, and other resource contentions
  • Advanced working knowledge of SQL and multiple versions of Microsoft SQL Server (2005, 2008, 2008 R2 and higher).
  • Understanding of SSIS integration with database systems including use of credentials and proxies.
  • Experience conducting database migrations between different platforms.
  • Experience upgrading databases from lower versions to latest versions of the database.
  • Background with database administration running on ASM storage.
  • Background in Develop/Test backup/restore shell scripts and implement in production systems.
  • Solid experience in setting up Data guard /Standby environments using ASM storage.
  • Minimum 4+ years of experience with logical/physical data design.
  • Knowledge of Server virtualization and storage concepts.

BASIC QUALIFICATIONS
  • Bachelor's degree in related technical discipline and 10+years of experience
  • Minimum 4+ years of experience with logical/physical data design
  • Microsoft Certifications ‘A’ Plus (MCITP SQL 2008, etc.) or OCA/OCP or DB2 Admin
  • Commendable Knowledge of various Enterprise level information security monitoring solutions.
  • Excellent written and verbal communication skills, interpersonal and collaborative skills, and the ability to communicate IT concepts to technical and nontechnical audiences.
  • Practical problem solving and trouble shooting skills.
  • Strong customer communication skills, with theability to communicate clearly with customers and technical personnel inhigh-stress situations

Essential Skills
  • Ability to work on various OS platforms.
  • Experience in working on Cloud based environments, adept with concepts of Database as a service (PAAS) is essential.
  • DBA for SQL servers, including performing installations and scheduling and managing backup, recovery, tuning, and other maintenance activities
  • Experience with troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues
  • Experience with performance tuning, query optimization, Performance Monitor, SQL Profiler, and equivalent monitoring and troubleshooting tools
  • Knowledge of indexes, index management, integrity checks, configuration, and patching and how statistics work, how indexes are stored, and how they can be created and managed effectively
  • Knowledge of SQL server tools, including Profiler, DTA, SSMS, SAC, SSCM, Perfmon, DMVs, and system specs
  • Advanced working knowledge of SQL and multiple versions of Microsoft SQL Server (2005, 2008, 2008 R2 and higher)


Key Skill(s)

Similar Jobs
View All Similar Jobs
Walkin for you