Virtue Software Technologies Hiring for Database Administrator at Hyderabad, Telangana Full Time

Full Job Description
The Database Administrator role is to ensure the stability, integrity, and efficient operation of the inhouse database systems that support core organizational functions. This is achieved by monitoring, maintaining, supporting, and optimizing all networked database systems. Senior database administrator applies proven communication, analytical, and problem-solving skills to help identify, communicate, and resolve issues to maximize the benefit of IT systems investments.

Key Responsibilities

Strategy & Planning
Review new database structures to ensure appropriate performance, indexing, redundancy, resiliency, and cost effectiveness.Collaborate with network staff to ensure smooth and reliable operation of software and systems for fulfilling business objectives and processes.
Acquisition & Deployment

Assists in the development, testing and operations of database systems.
Perform cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions.Evaluate acquired database systems and identify, protection and security remediation need to safeguard data and availabilityInteract and negotiate with vendors, outsourcers, and contractors to secure database-related products and services.
Operational Management
Plan, document and conduct database upgrade, data migration as the need arisePlan and periodically test fail over for redundant systemsReview database monitoring metrics to identify and correct performance bottlenecksMaintain an inventory of databases and key attributes for manageabilityGauge the effectiveness and efficiency of existing database systems; develop and implement strategies for improving or further leveraging these database systems.
Reviews and administers information security requirements for database system access to determine if they have been designed to comply with established standards.
Propose and create system design models, specifications, diagrams, and charts to provide direction to system programmer and development teams.Design and perform database server and security audits, database backup procedures, maintenance plans and other recovery processes in accordance with the company’s disaster recovery and business continuity strategies.Create and maintain documentation as it relates to system configuration, mapping, processes, and service records.Ensure compatibility and interoperability of in-house computing systems.Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems.Monitor and test system performance; prepare and deliver system performance statistics and reports.Implement replication and database clustering strategies for MS SQL Server.Ensure that new database artifacts meet company standards for readability, reliability, and performance.Proactively identify resource intensive queries and work with development teams on optimization strategies for improving performance.Advise and educate development teams on efficient database designs and best practices.Maintain documentation for the company’s MS SQL Server database environment.Perform regular database code migrations from lower environment to stage and production installationsPurge/Archive of large production tables and monitor their impact on SQL performance.Working with onsite/offshore team to trace the application problem.
Requirements

Knowledge & Experience
Proven experience in implementation of database systems, applications, and related products.Experience reviewing database system architecture and identifying improvement opportunities to proposed designsProven experience with implementing highly available database systems.Build database schemas, tables, views, and stored procedures.Experience on AWS services EC2, RDS, S3, CloudWatch, Database Migration Service, IAM.Knowledge on AWS services ECS, S3 Glacier, VPC, Subnets, Security Groups, Directory Svc.Advanced knowledge of security and configuration best practices including RBAC.Experience with managing all aspects of database administration in a Windows Server stand-alone and clustered environment by developing and maintaining backup and restore architecture, security management, service packs & cumulative updates installation.Advanced T-SQL skills including development and performance optimization.Experience in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub – Queries and Joins for complex queries involving multiple tables and exception handlers.Strong experience working on Disaster Recovery, High Availability concepts Always-On Availability Groups, Replication.Excellent understanding of the organization’s goals and objectives.Knowledge of applicable data privacy practices and laws.Good project management skills.Excellent written, oral, and interpersonal communication skills.Ability to conduct research into systems issues and products as required.Ability to communicate ideas in both technical and user-friendly language.Highly self-motivated and directed, with keen attention to detail.Proven analytical and creative problem-solving abilities.Able to prioritize and execute tasks in a high-pressure environment.Strong customer service orientation.Ability to work in a team-oriented, collaborative environment.
Education Background
The Database Administrator will have a bachelor’s degree and 3 years of related experience, associate degree and 5 years related experience, or 7 years related experience.Minimum of Three (3) years of database administration experience in a corporate environmentMaster’s degree a plusITIL certification a plusMS SQL Server certification preferred
Other IT related certification favorable

Skill
3+ years of SQL Server experience is required.1+ years of MySQL and Postgres experience required
Experience with optimizing queries required
Experience working in an Amazon environment highly desired
Linux and Telematic Experience is a plus
Experience using scripting languages to automate tasks and manipulate data; programming knowledge is a plus
Experience with building/testing/maintaining clustered, multi-AZ and replicated database systems
Experience developing technical diagrams and topology maps with various software applications.
Experience with all aspects of high availability fault tolerant architectures.
Ability to work in a fast-paced environment; ability to multi-task, change direction, effectively prioritize, and meet deadlines