SQL Developer/Network Administrator

About This Role

Who We Are:

• CAE Vision: Our vision is to be the worldwide partner of choice in defense and security, civil aviation, and healthcare by revolutionizing our customers' training and critical operations with digitally immersive solutions to elevate safety, efficiency and readiness.

• CAE Defense & Security Mission: CAE's Defense and Security business unit focuses on helping prepare military customers to develop and maintain the highest levels of mission readiness.

• CAE Values: Empowerment, Innovation, Excellence, Integrity and OneCAE make us who we are and we strive to make a difference in the world while helping each other succeed.

What We Have to Offer:

• Comprehensive and competitive benefits package and flexibility that promotes work-life balance

• A work environment where all employees are valued, respected and safe

• Freedom to succeed by enabling team members to deliver, take initiatives and make decisions

• Recognition, professional development, advancement and having fun!

Summary
Manage and maintain SQL Server databases to ensure their availability, performance, and security. Manage and optimize SQL databases to ensure efficient data storage, retrieval, and manipulation. Support, and monitor local LAN, WLAN, and WAN Infrastructure. Perform a variety of network maintenance, installation, and training tasks to ensure LAN/WLAN/WAN/VoIP services meet company and user requirements. Ensure

Essential Duties and Responsibilities
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Design and develop relational databases.
• Write and optimize SQL Queries, including CRUD operations.
• Provide database to application integration.
• Responsible for the installation, configuration, and upgrading of SQL Server software and related products.
• Ensure that data is accurately and efficiently moved between systems and that it is properly formatted and stored.
• Document configuration changes, current configurations, DBA activities, future plans, server activities, and standards.
• Inform IT management of system conditions and future needs.
• Responsible for monitoring and optimizing the performance of the database.
• Ensure the security of the database, including auditing, configuring security settings, and documenting security measures to protect the data from unauthorized access or breaches.
• Assist in maintaining corporate network services, features, and capabilities.
• Assist in maintaining existing and future government cloud platforms including Platform as a Service (PaaS), Infrastructure as a Service (IaaS), and Software as a Service (SaaS) environment in support of Department of Defense (DoD) cloud programs.
• Assist in the maintenance, troubleshooting, and support of network platforms in existing multi-tenant on premises and cloud/virtualized platforms.
• Communicate effectively with end-users, support staff, management and other systems departments on internal, cloud, and hybrid initiatives.
• Participates in the maintenance, troubleshooting, and support of local databases and network infrastructure within complex local and global environments.

Qualifications and Education Requirements

• Bachelor's Degree in a technology discipline or an equivalent combination of education and related experience.
• CompTIA Network+, CompTIA Cloud+, or equivalent certification.
• Minimum 2 years of experience in support and maintenance of complex network environment including cloud-based network segmentation/security appliances.
• Knowledge of IT Security policies as they pertain to NIST 800.171 and Security Information and Event Manager (SIEM).
• Knowledge of SQL Database optimization, data storage, retrieval, and manipulation.
• Knowledge of Network Services such as DNS, IPAM, (S)FTP, TFTP, LDAP, SMTP, and DHCP.
• Knowledge of Infrastructure Monitoring tools using SNMP, Netflow, and Syslog.
• Knowledge of 802.1x and certificates.
• Innovation/creativity, managing/working with others, project/process management, accountability.
• Excellent written and verbal communication skills and problem-solving ability.
• Learn and adopt best practices in Network Management.
• Ability to interface well with CAE users and customers at all levels.
• Ability to interface and work well with CAE Global IT Administrators.
• Due to U.S. Government contract requirements, only U.S. citizens are eligible for this role.

Preferred Skills

• Microsoft Certified: Azure Data Engineer Associate or IBM Certified: Database Associate
• Security+ and Cloud+ (Or equivalent IA cert) and CompTIA Network+.
• CCNP Cloud, AWS Certified Advanced Networking, Azure Administrator Associate, or Azure Security Engineer Associate.
• Knowledge and experience supporting a Microsoft Windows network.

Security Responsibilities

• Must comply with all company security and data protection / usage policies and procedures. Personally responsible for proper marking and handling of all information and materials, in any form. Shall not divulge any information, or afford access, to other employees not having a need-to-know. Shall not divulge information outside company without management approval. All government and proprietary information will be accessed and stored electronically on company provided resources.
• Incumbent must be eligible for DoD Personal Security Clearance.

Due to U.S. Government contract requirements, only U.S. citizens are eligible for this role.

Work Environment

• Must be able to work overtime, on and off-shifts as required.
• Duties performed in an office environment.
• The employee is on call 24x7 for the resolution of problems and issues.

Physical Demands

• The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
• Employee is regularly required to sit, talk or hear, in person, in meetings and by telephone.
• Manual dexterity to operate computers or other standard office equipment; and reach with hands and arms.
• Able to support rack mounted equipment (up to 7 feet off the ground).

Other Duties

• Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for their job. Duties, responsibilities, and activities may change at any time with or without notice.

CAE USA Inc. is an equal opportunity employer, and all qualified applicants will be considered for employment without regard to any protected characteristic, including disability and protected veteran status, as defined under federal, state, or local laws.

Applicants needing reasonable accommodations should contact their recruiter at any point in the recruitment process. If you need assistance to submit your application because of incompatible assistive technology or a disability, please contact us at hrops@caemilusa.com

Position Type
Regular

CAE thanks all applicants for their interest. However, only those whose background and experience match the requirements of the role will be contacted.

Equal Opportunity Employer

CAE is an equal opportunity employer committed to providing equal employment opportunities to all applicants and employees without regard to race, color, national origin, age, religion, sex, disability status, protected veteran status, or any other characteristic protected by federal, state or local laws. At CAE, everyone is welcome to contribute to our success. Applicants needing reasonable accommodations should contact their recruiter at any point in the recruitment process. If you need assistance to submit your application because of incompatible assistive technology or a disability, please contact us a t CAECarrieres-Careers@cae.com .