SUMMARY:
Responsible for performance, integrity and security of the database.
RESPONSIBILITIES
Installing and upgrading the database server and application tools
Allocating system storage and planning future storage requirements for the database system
Creating primary database storage structures (tablespaces) after application developers have designed an application
Creating primary objects (tables, views, indexes) once application developers have designed an application
Modifying the database structure, as necessary, from information given by application developers
Enrolling users and maintaining system security
Ensuring compliance with database vendor license agreement
Controlling and monitoring user access to the database
Monitoring and optimizing the performance of the database
Planning for backup and recovery of database information
Maintaining archived data on tape
Backing up and restoring the database
Contacting database vendor for technical support
Generating various reports by querying from database as per need.
Additional role requirements are likely to include planning, development and troubleshooting. Responsible for maintaining the consistency of data across database, maintains data integrity and data security. Also plan, design and developing database maintenance procedures and also help the development team to design the database based on business requirements.
ADDITIONAL RESPONSIBILITY:
SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure
Knowledge of data modeling principles
Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities
Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL).
Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
Maintain and improve already existing processes
QUALIFICATIONS
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
Please call Hemanth 9715166*** for more info.
Immediate joining or short notice preferred.
Thanks,
Hemanth
9715166***
,Why Choose Us: Creative Hands HR Consultancy is Start up firm, formed by young and dynamic entrepreneurs having experience and knowledge in US Financial Market recruiting. Our Business Approach: Systematic and streamlined methodology of recruitment The clear defined approach hel...