Database Administrator

Job description
Minimum Education: Bachelors’ Degree in Computer Science (or equivalent) and Engineering (or equivalent)Experience: 5-7 years related experienceDuties :The candidate is expected to understand business systems, processes and activities to offer comprehensive systems and Database Administration solutions with respect to Configuration, Administration, Monitoring, Security Management, Performance Tuning, Backup/Restore and troubleshooting. The candidate has to Configure and tune databases and operating system software to ensure optimum performance and resource utilization. He / She should function as the technical liaison between Application development, support and other DBA team/s, enforce enterprise security policies and procedures on databases. Candidate should be able to do implementation, configuring data source, queues/topics & deployment of code etc. with excellent analytical problem-solving skills.Requirement AnalysisAnalyze the Requirements from multiple teams (Development, Reporting, BA) collaborating with Business Operational users and Implement the requirements.Collaborate with Third Party Admins, Business Analysts and support along with other architects and System analysts to identify data requirements by each business departments.Database Design/optimization processEstablish, oversee, and optimize all database maintenance & backup processes.Create system design specifications based on the requirements gathered, which will include database parameters or specifications.Create Data Design artifacts that define technical data specifications, and transformation rules; and deliver, gap analysis, impact analysis.Project executionPrepare, maintain and execute disaster recovery plans and delivery methodologies.Query performance optimization, tuning implementations.Manage backup and recovery of databases.Monitor and report system performance and resource consumption trends to assure production systems meet availability requirementsCreate data backup to prevent loss of information and provide technical support for Database maintenance and resolve issues.Monitor databases for errors and perform problem determination when necessary. Develop process automation scripts to enhance the efficiency of operationsDatabase TestingParticipate in release planning and help development team to accordingly deploying the changes in to production, UAT and QA environment.Project Documentation and Quality Standards/proceduresEstablish standards, controls, and procedures to ensure data integrity and security.Follow and implement the enterprise wide standards on data governance, privacy while designing and development of databases, security framework and data archivalMaintain Data dictionary, meta data management, Master Data management and reference data management, naming convention and develop procedures to be followed by developers.Document and communicate database schemas, using accepted notations, development standards and performance metrics.Team Coordination / Client InteractionProvide assistance to developers in DBMS performance tuning, best practices architecture and problem resolution.Design user interface self-service tool to enable business users to create reports as per their requirements.Design new databases and integrate them with business toolsConfigure databases with various clients and resolve user issues.

United States
Washington
Bothell Show on map Get directions