MS SQL DBA Administrator

JOB LOCATION: Changi Business Park Crescent Singapore
JOB TITLE: MS SQL DBA ADMINISTRATOR

Job Description
· Provide MSSQL database administration service .Following standard team processes.
· The individuals will be expected to be fully-functional 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

Qualifications:
· 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 on-call 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