Database Administrator - II Apex Group Ltd (India Branch)
Apex Group Ltd (India Branch)
Office Location
Full Time
Experience: 3 - 3 years required
Pay:
Salary Information not included
Type: Full Time
Location: Hyderabad
Skills: SQL Server, Database Administration, Performance monitoring, Query Tuning, Change Management, Capacity Planning, data integrity, security management, Replication, Stored procedures, Documentation, Service Pack Upgrades, Highavailability solutions, Disaster recovery solutions, Backups, Restoration, Index Management, Business Processes understanding, Stakeholder Communication, BI Infrastructure
About Apex Group Ltd (India Branch)
Job Description
The Role & Key Responsibilities: The role of the Database Administrator will be responsible for the management of software development teams within the Apex and report to the DBA Manager . The role of the database administrator is to be responsible for the performance, integrity and security of a number of core SQL databases. The successful applicant will be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. They will take ownership of multiple test, development and production environments and be responsible for the maintenance of these environments to ensure all databases and servers are performing optimall y. Responsibiliti es: Installation, administration and maintenance of multiple SQL Server instan ces.Setup environments for use within the end to end software delivery lifecy cle.Define, design & implement control procedu res.Backup monitoring and continuous review of the backup strat egy.Troubleshoot and resolve issues quic kly.Performance monitoring and tun ing.Query tuning (Index maintenance and management, housekeeping, memory, CPU, Disk I/O e tc.)Planning and execution of Service Pack upgra des.Work alongside project teams (analysts, developers, testers and implementation managers) during software release and patch ing.Adhere to change management procedu res.Working closely with other team memb ers.Complete structured and systematic test ing.Track and report on regular tasks executed to ensure system availability maintaining a continuous improvement road map.Pro-actively identify productivity opportunit ies.Ensure correct procedures are adhered to as tasks are being progres sed.Experience in a Windows based 24/7 environment including 1st/2nd line supp ort.Involved in the design and build of new systems, including high-availability and disaster recovery soluti ons. Skills Requ ired: Create and manage multiple databases and assist in capacity planni ng. Monitor, maintain database systems and troubleshoot problems that may ari se. Maintain data integrity and security (manage roles and permissions of database user s). Develop strategies and implement solutions for managing back-ups, restoration and replication & create, manage constraints and index es. Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedur es. Create detailed documentation including diagrams of database infrastructu re. Learn relevant business processes and understand the data flow, criticality and dependenci es. Effectively coordinate and communicate with all the stakeholders (internal teams and clients) & set up and maintain database infrastructure for the companys BI nee ds.,