Job: Database Developer (USA) Job

This posting has expired and is no longer available.

Browse Similar Jobs: IT - Computer Services & Support IT - Software/Development

Jobing Description

Database Developer (USA)-709180

Description
Database Administrator (Teradata)

Level: Principal Associate

Responsible for administration of procedures and practices regarding data access and upkeep for a specific database technology. Works with project teams to determine changes needed to the database, models and implements the changes. Supports the ongoing project efforts and day-to-day support activities for the department.

Responsibilities:
- Manages and maintains data in all production and non-production databases and replication servers. Maintains security database; generates reports, queries and documenting. Works with project teams to identify database changes needed to implement project o
- Manages database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers and declarative integrity constraints.
- Sets up access privileges to databases. Creates and maintains user profiles for database access, including login and password. Configures database parameters, and prototypes designs against logical data models.
- Monitors database for resource utilization. Handles and supports testing and reporting. Manages database distribution, security and access requirements.

- Create, maintain, and support database architectural environment
- Physical database design
- Administration of production objects in change control environment
- Development of pro-active processes for monitoring capacity and performance
- Perform system level and application level tuning
- Support the application development teams for database needs and guidance
- Support of production processes
- Support of end user queries
- Database security administration

Qualifications
Basic Qualifications:

- Bachelor's Degree and/or at least 3+ years experience in any RDMBS database administration
- 1-3 years experience with Teradata database administration/development activities including but not limited to: creating, maintaining, and supporting data warehouse structures, managing security, capacity planning, performance tuning
- Proficient in Teradata database tools & utilities (TTU) and data warehouse concepts
- Ability to read the logical model and understand entity relationships

Preferred Qualifications:

- Experience with Teradata version V2R12 or higher
- Teradata Certified Professional or Teradata Masters certification
- Logical Data Modeling experience
- Hands on experience with ERWin Modeling software
- Database administration experience with DB2, Oracle or SQL Server
- Scripting knowledge to develop reusable code using UNIX, VBA, etc.
- Experience working with geographically dispersed delivery teams
- Experience performing under various Solution Delivery methodologies (Agile, Waterfall, etc.)
Skills:

- Very strong subject-matter knowledge in physical database design and database security administration
- Excellent communications skills
- Effective in team environment
- Demonstrable excellent work ethic and fast learner
- Ability to adapt and work well under conditions of a rapidly changing environment

At this time, Capital One will not sponsor a new applicant for employment authorization for this position.

No agencies please. Capital One is an equal opportunity employer committed to diversity in the workplace. We promote a drug-free work environment. We emphasize recruiting, hiring, and retaining the most qualified candidates and providing them with the opportunity to meet their potential. We provide an environment where differences lead to solutions.

Job: Information Technology
Primary Location: United States-Virginia-Richmond-Richmond-West Creek 6 (12076)
Schedule: Full-time
Travel: No