Database Administrator
At a glance
Mid-level Data Architecture & Governance role at AccionLabs. Singapore, , Singapore · full-time.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Install and configure MSSQL Server, Analysis Services and Reporting Services on standalone Windows systems and clusters
- Handle database setup through retirement, including monitoring alerts, managing space and users, and applying upgrades or migrations
- Use MSSQL tools and named backup products to protect databases and restore service when recovery is needed
- Investigate production performance, connection, security and corruption problems, including replication and high-availability faults
- Improve operational processes and automate support tasks, including debugging PowerShell and Perl scripts
What you bring
- You have five to eight years of relevant experience and strong knowledge of ITIL and operational processes
- You can administer MSSQL databases across Windows servers, including clustered installations, backups, recovery and high-availability setups
- You bring strong PowerShell and Perl skills for Windows-based infrastructure support
Who this fits
This mid-level, on-site role suits a database administrator comfortable supporting critical production systems and working across MSSQL and Sybase. Sybase administration, Linux, named monitoring and recovery tools, and ticketing-system experience are additional advantages.
From the employer
Accion Labs is a global technology services firm with offering a full range of product life-cycle services in the emerging technology segment. This includes Web 2.0, Open Source, SaaS/Cloud, Mobility, IT Operations Management/ITSM, Big Data and traditional BI/DW.
Through nine global offices and a rapid-response delivery model, Accion offers a range of engagement models such as turn-key projects, extended-teams, shared-IP development, offshore-leveraged engagements and professional staffing (contract, contract-to-hire & direct perm).
Role- Database Administrator
Job Description
· 5-8 Years, excellent knowledge on technology areas, ITIL process, Operational Processes, Training & documentation.
· Installation of MSSQL Server, Analysis & Reporting Services on Window standalone & Cluster environment.
· Database Lifecycle Management - Database creation, setup & decommissioning.
· Database event/alert monitoring, space management, user management
· Database upgrades, migrations & refreshes.
· Database backup, restore & recovery using MSSQL native methods, Quest Lite speed &Commvault.
· Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment.
· Capable to perform MSSQL database setup, database upgrades, space management, backup & recovery
· Setup and maintain High-Availability and Disaster Recovery solutions (Log shipping, Mirroring, Replication) in MSSQL using MSSQL Client tools.
· Setup and manage native and Quest Lite speed managed database recovery model
· Familiar in Windows system administration relevant to MSSQL database management. (Window 2003, 2008 Enterprise Edition)
· Experience in supporting multiple MSSQL Server installations on a single box & in multi node cluster environment.
· Experience in troubleshooting MSSQL Log Shipping, Mirroring & Replication problems.
· Propose and/or participate in ongoing process improvement programs, automation projects.
· Strong PowerShell & Perl skills in Windows environment, debugging infrastructure support scripts in case of issues or / for better management.
· MSSQL resources are required to work on Sybase and vice-versa.
· Knowledge in Sybase database administration, Linux, BMC SQL BackTrack, BMC Patrol, Commvault are a plus.
· Experience in ITIL process & ticketing systems is added advantage
All your information will be kept confidential according to EEO guidelines.