Database Administrator (SME) Subject Matter Expert
Diaconia is looking for a talented Management Analyst (Senior) to join our Amazing team!If you're looking to join a company that truly appreciates you and your talents, look no further! At Diaconia, we are committed to serving and caring for our colleagues, our clients and our community. Our team is made up of talented individuals who appreciate having the opportunity to contribute their knowledge and experience to further the growth and development of our industry. Our ideal candidates embrace diverse thinking, enjoy partnering with others and are seeking to make a difference! ACTIVE DoD SECRET CLEARANCE REQUIRED NO EXCEPTIONS We are currently searching for a new, full-time member for our team for the position of:Database Administrator (SME)Lead team of Database Administrators to deploy and manage relational database management systems (RDBMS) that store, secure, index, and facilitate retrieval of DEA data.Recommend database platforms and configurations to meet DEA needs. Manage database performance, security, and integrity.Manage RDBMS systems including but not limited to Oracle, SQL Server, and MySQL.Support development teams in data normalization, query tuning, and stored procedure optimization.Develop DDLs to create and update data structures.Develop indexes to speed queries and apply masks to improve data integrity. Implement security features such as data obfuscation and data encryption.Monitor data backups, storage, growth, and usage.Report potential issues and recommend solutions, such as extensions, archival, and compressions.Manage routine maintenance and backups.Monitor performance alerts and restore performance before users are impacted when possible.Respond to trouble tickets.Support application deployments.Manage patches, fixes, and upgrades to maintain currency per DEA standards.Develop jobs to import and export data to interfacing systems, data warehouses, data lakes, and for use by data analytics tools.Strong DBA, mostly Oracle, with some SQL knowledge (Senior: 7-10 years).ACTIVE US Government DOD SECRET CLEARANCE REQUIRED - NO EXCEPTIONS ACTIVE US Government DOD SECRET CLEARANCE REQUIRED NO EXCEPTIONS Diaconia is An Equal Opportunity Employer. We provide equal employment opportunities to all employees and applicants for employment, without regard to race, color, religion, sex, age, national origin, disability, genetic information, sexual orientation, gender identity, protected veteran status, or any other basis prohibited by applicable law.