Qualification:
• University Degree in Information Technology/Computer Science or Equivalent (Master's degree is preferred).
• Must be MCSE certified.
• Must be MS SQL Server Certified.
· Preferable to be Oracle Certified Professional - DBA .
Required Experience:
· At least 15-year experience in RDBMS Administration
· Expert in MS SQL Server 2008/12/14/17 /19 and other RDBMS like Oracle.
• RDBMS Clustering experience.
• Backup and recovery practices in SQL Server.
• Experienced in RDBMS SQL Server application tuning.
• Strong knowledge of SQL Server Administration (DBA) best practices for performance and growth optimization.
• Capacity of SQL Server monitoring and management.
• SQL, T-SQL, and PL/SQL Programming and development experience and proficiency is required.
• Capable of creating Stored Procedures and Triggers with high proficiency.
• Backup and recovery experience at a first-person level required SQL Server Security Experience
• Experience with RDBMS Backup and Recovery
• Proficient on SQL Server patching and upgrades, including out of place upgrade.
• Knowledge of Windows Active Directory, EMC storage, Centera, VMAX, EMC Networker, DATA Domain, VMware, V-Sphere and V-Centre is a plus.
Technical Duties & Responsibilities:
• Installation, Configuration, administration and maintenance of sql server (and/or oracle) for testing, development and production environments.
• Create Users and assign permissions based on the level of database access the user (Security).
• Create Linked Servers to SQL Servers and other databases such as Oracle etc. (Security and General Administration).
• Design database including complex data models and logical database designs.
• Backup and Restoration Strategy (Database Backups and sql server agent.
• Perform and maintain Backups, monitor backups regular
• Setup High-Availability as per Disaster Recovery Strategy for the Databases (Failover Clustering, Database Mirroring log shipping and Replication).
• Troubleshoot various problems that arise in a day-today work and fix the issues. (Monitoring Error Logs).
• Plans and conducts structured testing of database designs to confirm functionality and performance.
• Performs routine and customary operational and monitoring activities to ensure database integrity, stability, availability and capable of meeting ongoing business needs.
• Evaluates technology and techniques to implement and maintain databases.
• Accepts the lead for projects as assigned and contributes as a team member to other projects in an ongoing manner.
• Work directly with development groups helping design DB to interact efficiently with the database.
• Documenting major changes to the SQL Servers and providing reports to management.
• Apply Service Packs and updates as needed.
• Support local staff in improving their skills and expertise.
• Prepare and Conduct technical presentations.
• Do other assignments related to RDMS system as requested.