What are the responsibilities and job description for the Senior Database Architect position at Astyra Corporation?
Job Description
Job Description
Senior Database Architect
This is a primarily remote position with occasional onsite requirements
Description :
The clients’ IT Enterprise Level Data Warehouse Technical Specialist will provide advanced architect lead technical expert support and requires experience in systems development tools and techniques.
This position requires excellent communication analytical and organization skills and the ability to translate business and technical ideas and issues into clear and concise language excellent customer service skills can contribute and work within a team environment and can communicate effectively and professionally in verbal and written form with management and co-workers.
Advanced knowledge of cloud OCI AWS or Azure database systems is required along with experience in modifying or developing complex interrelated applications and solutions.
The role involves linking technical expertise with business research or instructional needs ranging from consulting services software or hardware recommendations to the development of integrated automated systems.
Duties include client needs assessment as well as evaluating hardware availability and software requirements.
This position will be responsible for various activities related to the design implementation and maintenance of complex Oracle and SQL Server databases.
Experienced in supporting applications based on various platforms and technologies such as IBM Mainframe, Sun Solaris UNIX Database platforms and tools, Oracle SQL Server, DB2, MS Access, SAS, DI Integration, Unix shell script, C / C, SQL query writing, Stored Procedures, FTP Encryption / Decryption tools, IIS Apache HTTPD, Apache Tomcat, TCP / IP Network Firewall, VM Architecture, SSL Certificate Tools, Active Directory, VPN, Solaris, VI Editor, Curl, X Windows, Word, Excel, IE, and Firefox.
Experience with ETL structured system development methodologies data transfer and interface methodologies between mainframes and servers and distributed server environments in a statewide environment.
Required Skills / Knowledge / Experience :
Extensive experience with Database platforms and tools (Oracle, SQL Server, DB2), Required 10 Years
Experience in deploying and managing databases on cloud platforms (OCI, AWS, or Azure) including cloud-native monitoring, backup, and recovery, Required 5 Years
Experience in integrating on-prem and cloud databases using tools such as Oracle Data Integrator, AWS DMS, or Azure Data Factory, Required 5 Years
Experience with data cloud migration projects including expertise in planning, execution, and optimization of data pipelines and storage in cloud, Required 5 Years
Experience with supporting applications based on various platforms and technologies such as Sun Solaris (UNIX), Required 10 Years
Experience with supporting applications based on Linux OS, Required 10 Years
Experience with supporting applications based on various platforms and technologies such as IBM Mainframe, Required 5 Years
Experience in migrating mainframe-based data to modern relational databases, such as Oracle or SQL Server, Required 5 Years
Experience in writing, debugging, and optimizing Unix Shell scripts to automate tasks and manage processes within Unix-based environment, Required 10 Years
Experience with C / C , SQL query writing, Stored Procedures, FTP, Encryption / Decryption tools, Required 10 Years
Extensive experience with ETL, structured system development methodologies, data transfer and interface methodologies, Required 10 Years
Experience with TCP / IP, Network, Firewall, VM Architecture, SSL Certificate Tools, Active Directory, Required 5 Years
Able to work without assistance and able to manage high complexity work efforts., Required 10 Years
Proper email communication will only be done to and from @astyra.com email addresses. Please ensure you are communicating with approved Astyra recruiters by checking this point when receiving offers and messages from us. Please ensure you are communicating within these guidelines and proper channels for the quickest possible interview consideration! ?
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Senior Database Architect?
Sign up to receive alerts about other jobs on the Senior Database Architect career path by checking the boxes next to the positions that interest you.
