Database Architect

Please send your resume to Krishna Kushwaha (kkushwaha@citi-us.com) and Roopa Guddimath (rguddimath@citi-us.com) by email. Please include the Job Title in the subject line of your email for the job position you are applying.

Job Type: 
Full-Time
Location: 
Falls Church VA
Organization Unit: 
State & Local Government
Date Opened: 
Mon, 07/22/2019
Start Date: 
ASAP

Description/Role

The Database Architect is responsible for analyzing agency operations, applications,
programming, and objectives to determine database structural requirements; They will analyze
database implementation methods to make sure they are in line with industry best practice and
any external regulations.  The Database Architect will define database physical structure and
functional capabilities, security, backup, and recovery specifications; In addition, they will design
strategies for enterprise database systems and implement standards for operations,
programming, and security.  Databases will be designed to support business applications,
ensuring system scalability, security, performance and reliability;

•  Design database applications, such as interfaces, data transfer mechanisms, global

temporary tables, data partitions, and function-based indexes to enable efficient access

of the generic database structure in an Agile environment; 

•  Develop database design and architecture documentation for the management and

executive teams; 

•  Collaborate with technical architects, product strategist, business analysts, and others to

understand business requirements; Integrate new systems with existing warehouse

structure and refine system performance and functionality in an Agile environment; 

•  Plan and install upgrades of database management system software to enhance

database performance; Identify and correct deviations from database development

standards; Identify and resolve production and application development problems;

Create and enforce database development standards in an Agile environment; 

•  Develop or maintain archived procedures, procedural codes, or queries for applications;

Develop load-balancing processes to eliminate down time for backup processes; 

•  Develop data models for applications, metadata tables, views or related database

structures; 

•  Develop modeling strategies to ensure that the database is secure, scalable and

performs reliably; 

•  Identify, evaluate and recommend hardware or software technologies to achieve desired

database performance; 

•  Monitor and report systems resource consumption trends to assure production systems

meet availability requirements and hardware enhancements are scheduled

appropriately; 

•  The Database Architect will be responsible for constantly monitoring the database and

immediately addressing database issues and problems;

•  The Database Architect will be required to design and maintain a standard connectivity

method for data transfers.

•  Will need to set up and maintain repository for batch reports.

Minimum Qualifications

•  8+ years’ experience
•  Bachelors Degree in Computer Science
•  Five (5) years of experience in data analysis or the design and development of relational
database management systems (RDBMS) such as SQL, DB2, and Oracle on projects
similar in size and scope to the CCWIS project;  
•  Four (4) years of experience in overseeing the database development, programming,
database optimization techniques, and maintenance of enterprise level software
applications;  
•  Must have proven ability to work in distributed systems;
•  Must have a minimum of 2 years of experience in developing and implementing an
enterprise data warehouse;  
•  Must have a minimum of 2 years of experience with OLAP and OLTP;
•  Must have experience developing and implementing a RESTful API for a relational
database; 
•  Excellent written and communication skills;
•  Ability to contribute toward creating a harmonious results-oriented team;
•  Experience and proficiency in mentoring staff;
•  Experience and proficiency with Microsoft Office products.
•  Two (2) years of experience in developing and implementing software in Agile
environments.

Prefered Skills

o 2/3 years working with State governments
o Experience in CiCD environment
o Experience in Child Welfare domain (SACWIS Systems)

LOA: 
Permanent