<!– /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:”"; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:”Times New Roman”; mso-fareast-font-family:”Times New Roman”;} h1 {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:1; font-size:24.0pt; font-family:”Times New Roman”; font-weight:bold;} p {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:”Times New Roman”; mso-fareast-font-family:”Times New Roman”;} @page Section1 {size:8.5in 11.0in; margin:27.0pt 1.25in .25in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} –>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:”";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”;
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
Purpose of Job Description:
This Job Description is intended to describe the main functions and responsibilities required of the role. It is not to be construed as an exhaustive list of all responsibilities or duties that may reasonably be required of the incumbent in this role.
|
KEY RESULT AREAS (KRAs) |
KEY OUTPUTS |
MEASUREMENT CRITERIA |
|
||
| 1.Database Development |
·Design Database schemas for high performance, high availability database ·Designing databases for heavy traffic applications ·Development and optimization of SQL Stored Procedures, Triggers, User defined functions, Queries ·Performance tuning ·Identifying bad queries and reporting to the teams ·Solid grasp of advanced SQL query techniques in addition to experience with automating, export/import tasks using DTS/SSIS., Expertise with configuring, implementing and supporting high availability SQL Server. · Expert in Stored Procedures and SQL Coding. · Expert in query, index and Database IO performance tuning. · Expert understanding of Database design principals, normalization of data vs. performance, etc.
|
· Performance of the queries ·All documentation complete and accurate |
|
||
|
2.Ensure Database Services at maintained to an Optimal standard |
· Design Database schemas for high performance, high availability database ·Install, configure and maintain SQL Server databases · Perform database backups and refreshes · Prepare capacity planning and sizing, Troubleshoot and resolve database issues in a timely manner · Plan & implement and maintain security at the database level · Expert understanding of the SQL Server architecture administration and security. · Understanding of Windows Server, and Open Source (Linux-based) operation systems. · Solid Understanding of enterprise level hardware systems including: RAID and SAN, and NAS commonly used in fault tolerant production environments. ·Ability to proactively identify, troubleshoot and resolve live database systems issues. · Ability to manage all database maintenance plan activities including backups, indexing, integrity and consistency checks, etc. · Experience supporting SQL Reporting Services and standard reporting tools. · Experience running and supporting large databases under high transaction rates. · Ability to research new database/warehouse storage/performance methodologies.
|
· Minimal outages or disruptions to business · No downtime due to security or reliability issues · All systems/technology well maintained and managed · All documentation complete and accurate · No surprises and risks managed proactively |
|
||
|
1. Other |
· To undertake any special projects an/or ad hoc assignments as required |
· Positive feedback from Operations Manager |
|
||
|
|
KNOWLEDGE AND SKILLS |
· Strong working knowledge of Data Warehousing methodologies, architectures, and development best practices · Strong knowledge of ETL design and implementation using standard industry tools and best practices · Strong working knowledge of meta-data management and data quality/governance processes · PL/SQL development skills in SQL Server and MySQL platforms. ·MySQL, and SQL Server Tuning, and Optimization, Slave / Master Configuration, and load balanced database configurations
|
|||
|
|
EDUCATION, QUALIFICATIONS, SPECIAL TRAINING REQUIRED |
· Bachelors Degree in Computer Science (Masters Preferred) · Degree/Certificate in Database Administration with a specialization in SQL Server · MS SQL Server DBA Certificate a plus
|
|||
|
|
WORK EXPERIENCE |
· Must have at least 5+ years experience maintaining heavily trafficked enterprise level database installations covering both SQL Server, and MySQL. · 5+ years experience as a Database Administrator with experience in Data Warehouse data analysis, and data modeling conceptual, logical, and physical data design
|
|||
Filed under: indwell it jobs | Tagged: * Home * Search * IT JOBS * NON IT Jobs * ITES JOBS * News You're here: Home DBA, Data base, data base administrator, Data base designer, hyderabad jobs, indwell, indwell consultancy, indwell jobs, jobs, Sql stored procedures, triggers, www.indwell.co.in | Leave a Comment »