Ms SQL Dba Administrator - Singapore - Wipro Limited

Wipro Limited

Verified Company

Singapore

1 week ago

Posted by:

Wei Jie

beBee Recruiter

Description

Singapore, Singapore

Tech Hiring
Provide MSSQL database administration service.

Following standard team processes.

The individuals will be expected to be fullyfunctional DBA's who can perform traditional DBA activities.

From an operational perspective, responsibilities include troubleshooting problems, working maintenance windows and providing 24x7 on-call support on a rotational basis.

Report Patches required
Patch Testing
Patch rollout on production
Start up and shutdown of Database instances
Job scheduling
Verify all Instances and dependent services are running
Look for any new error log entries
Session / Process Monitoring
Query or Transaction monitoring
Lock and Deadlock monitoring
Activity / Transaction Log monitoring
Job monitoring and Purging Job history
Replication / Log shipping monitoring
Monitor Space usage /growth of Database objects
Verify free space in file groups / databases
Monitor transaction log growth and truncate schedule
Reorganization of DB to remove fragmentation
Update Stats for hot objects
Purging of DB logs and trace files
Schedule maintenance plans for maintenance like DBCC REINDEX / INDEX DEFRAG
Creation of maintenance plans and jobs for update stats, defragmentation
User / Schema Creation
User Management
Roles and Privileges Management
Look for security policy violations
Privileges & Access controls on Database
Verify that the database backup was successful
Backup execution and monitoring
Perform drill to test and execute recovery in different recovery scenarios
Database Connectivity issues
Slow response
Operations timed out
Database incident and error resolution
Transaction Log Backup Stuck for Space
Database incident and error resolution
Vendor Management
System Performance Monitoring
Maintaining Environment details
Use Profiler to obtain expensive & most frequent queries
Basic knowledge of SSIS and SSRS

Qualification:

As per the Project Requirement

Expected Skills / Experience (L1 / L2 / L3) : L1

At least SQL DBA experience, 1.5 + years required
Fundamental Knowledge of Windows Operating System
Strong in SQL Server fundamental
Knowledge of Basic SQL statements, DB startup, shutdown, DB Sizing required
SQL coding and tuning experience desired
Excellent communication Skills
Prior experience in a 24x7 environment desired
Strong analytical and troubleshooting skills.
Provide oncall support as and when required
Team player who has a customer focus and brings expertise to the team

Additional Qualification / Skills:

MCSE MSSQL Certification is recommended
Knowledge on Log Shipping
Knowledge on any of the SQL server 2000, 2005, 2008 Versions.

Personal Attributes:

Accepts Responsibility
Openness
Positive attitude
Integrity
Commitment
Judgement
Organized
Proactive
MSSQL Database Admin

We are an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, caste, creed, religion, gender, marital status, age, ethnic and national origin, gender identity, gender expression, sexual orientation, political orientation, disability status, protected veteran status, or any other characteristic protected by law.