Database Designer/Administrator

 

Minimum Technical Qualifications/Experience:  Overall five years experience in analyzing, designing , and administering databases (Oracle, MS SQL, DB2, DMS, Sybase).

 

Functional Responsibility:  Responsible for designing the database. This includes the design of the tables, fields, screens, triggers and stored procedures so as to optimize the database performance (efficiency, reliability, scalability). Will analyze database systems and programs, which include access methods, access time, file structures, device allocation, validation checks, statistical methods, and security. Will also work with user community to understand data access and integration needs, ensure integration of systems through the database structure, perform data modeling, monitor database standards and procedures, system usage and performance, troubleshoot and resolve database and data problems, and develop and administer disaster recovery plans. Other responsibilities may include:

 

-     Maintaining and creating Users, Nodes, Instances, Databases, Tables Spaces, Containers, Buffer Pools and Logs.

-     Installing the database on the server as well as installing the clients.

-     Migrating data between databases.

-     Extracting data from one system into flat files and then loading into the database without constraints.

-     Writing Stored procedures, Triggers to populate data from non-constraints tables to normalized tables with constraints.

-     Tuning the database manager configuration, database configuration parameters like Bufferpools, Shared Memory variables, I/O variables, Application heap, Database heap size, Logs and Sort area to increase performance of the system.

-     Analyzing the execution path of the query to determine the cost, indexing and cardinality.

-     Writing scripts to create instances, databases, scheduling online, offline backups and restoring databases.

-     Implementing Active- Standby Clustering, database partitioning using utilities.

 

 

Also, provides highly technical expertise and guidance in the design, implementation, operation and maintenance of database management systems (DBMS). Evaluates and recommends available DBMS products after matching requirements with system capabilities. Determines file organization, indexing methods, and security procedures for specific applications. Controls the design and use of databases. Controls the global view of databases, controls the access to the databases, assures the safekeeping of the databases (from accidental or intentional damage or loss), and monitors the use of databases. Must be capable of defining all required database administration policies, procedures, standards, and guidelines. Is an authority on the design of databases and the use of database management systems. Evaluates and recommends available DBMS

products after matching requirements with system capabilities. Prepares and delivers presentations on DBMS concepts.

 

Minimum Education: Bachelor