SQL Developer/Network Administrator

CAE • Dothan, AL

1d

About The Position

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.

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.
• 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.
• 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.
• 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).

Nice To Haves

• 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.

Responsibilities

• 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.

Benefits

• 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!

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees