Database Engineer (Mid-Level)
Database Engineer (Mid-Level) Position Description CGI Federal is looking for a mid-level Database Engineer who will establish database management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan, and security policy. Your future duties and responsibilities Adapts business requirements, developed by modeling/ development staff and systems engineers, and develops the data, database specifications, and table and element attributes for an application. Documents and communicates database design. Evaluates and installs database management systems. Codes complex programs and derives logical processes on technical platforms. Builds windows, screens, and reports. Assists in designing user interface and business application prototypes. Participates in quality assurance and develops test application code in client server environment. Provides expertise in devising, negotiating, and defending the tables and fields provided in the database. At more experienced levels, helps to develop an understanding of client's original data and storage mechanisms. Determines appropriateness of data for storage and optimal storage organization. Determines how tables relate to each other and how fields interact within the tables for a relational model. Required qualifications to be successful in this role Bachelor's Degree is required plus 2-5 years of relevant experience Knowledgeable of federal laws and regulations, directives, instructions, policy, standards, and guidance, so that requirements support security and privacy compliance. Knowledgeable of FedRAMP requirements and guidance.Leads, directs or is responsible for implementation and compliance with information security/information assurance policies, privacy policies, access controls, data integrity, and database systems.Experienced in database management and data administration support for medium-to-large databases. Advises/presents on best practices and provides support for database management and administration tasks such as standardizing data names, definitions, usage, and structures.Leads and directs database specialists to manage databases, manage database projects, and provide database administration functions.Experienced in database structures including design, normalization, documentation, file organization, and indexing and tuning of the design to make sure applications can make efficient use of the data contained within the database. Leads, directs or responsible for creating, mirroring, backup, tuning data warehouses and implementing, managing and tuning data mining tools , makes recommendations on set up, selection, security, and management thereof.Provides design and development of interface capabilities between database systems and other management systems to support access and usage of programmatic data. Manages access and usage of databases including data security.Works with business analysts and clients to make sure functional requirements are embedded supported by the database and application developed during the SDLC.Develops or directs the development of database documentation such as logical and physical database design, normalization diagrams (ie, Entity Relationships), and any other documentation necessary to use for the SDLC phases of design to coding.Leads, advises or oversees the critical database usage standards, procedures and conventions. Advises on new technologies and best practices in this area.Presents technical briefings on designs, recommendations, project progress, status, issues, and solutions on data administration and database development projects.Advises, evaluates, tests recommendations for newer technologies that can improve database management, access, security, of traditional datacenter -based databases, distributed and cloud based databases. Understands and can lead, direct, develop, and set up SQL programs. Understands and can work with different database structures including hierarchal, relational, and object-oriented systems in a centralized or distributed environment.Must have excellent oral and written communication skillsDesired Certifications in: Database software, PMP, etc. At CGI, we're a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 65,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com.This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans.We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please.All CGI offers of employment in the US are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary depending upon specific assignment, or upon any US government security clearance if required. Qualified applicants will receive consideration for employment without regard to their race, color, religion, sex, gender Identity, sexual orientation, national origin, age, disability, veteran status, pregnancy, or other status protected by law. CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with CGI's legal duty to furnish information. Skills Database Reference 537104 Company Description: At CGI, we are a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 68,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com. This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please. Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, protected veteran status or disability.