MS SQL DBA Administrator

JOB LOCATION: Changi Business Park Crescent SingaporeJOB 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

• 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

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

• Accepts Responsibility
• Openness
• Positive attitude
• Integrity
• Commitment
• Judgement
• Organized
• Proactive