What are the responsibilities and job description for the Senior Oracle/SQL Server DBA position at Resourcesoft, Inc.?
Requirements
-
10 or more years of experience engineering and administering Oracle and Microsoft SQL Server enterprise databases.
-
Proficiency in programming with T-SQL and PL/SQL to develop complex queries and stored procedures.
-
Experience in managing Sun Solaris Unix environments alongside Oracle WebLogic and Fusion Middleware.
-
Experience with modernizing enterprise data architectures utilizing Azure Synapse and Databricks platforms.
-
Experience in constructing and automating robust ETL data pipelines, SSIS packages, and CRON scripts.
-
Experience with deploying advanced business intelligence dashboards utilizing Power BI and Tableau.
-
Excellent communication skills to collaborate with cross-functional teams and mentor junior technical staff.
Responsibilities
-
Execute comprehensive database administration, server maintenance, and seamless software deployment migrations.
-
Optimize database structures and tune complex SQL queries to maximize enterprise application performance.
-
Automate critical administrative workflows utilizing SQL Server job schedulers, SSIS packages, and ETL pipelines.
-
Manage and configure Oracle WebLogic servers and Sun Solaris operating environments to ensure high availability.
-
Design logical data models and enforce strict data integrity protocols across complex relational database architectures.
-
Evaluate and transition legacy on-premises databases into modern Azure Synapse cloud data warehousing solutions.
-
Produce standardized technical documentation and conduct rigorous quality assurance validation for all system changes.
Founded in 1999, Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization. Headquartered in Marlborough, MA, the company serves the technology needs of its clients nationwide. Resourcesoft has often been recognized by prominent rating agencies for its exemplary growth and stability. With over two decades of industry experience, the Company has evolved as a front runner in enabling project optimization. We partner with leading organizations to provide technology solutions within the financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We take pride in mentoring a workforce that is well positioned to respond to the emerging IT trends and needs. With the employees at the crux of every business endeavor, our success is driven by our expertise in pairing the right talent with the best jobs in the technology sector. We forge long term, personalized relationships with our employees to advance their career to the next level. We engage them in technology centric client projects that provide opportunities for them to evolve, innovate and deliver world class products and services. Our career opportunities offer challenging assignments and exposure to emerging and cutting edge technologies. We are committed to providing our employees with the tools necessary to accelerate their career progression, while maintaining a healthy, work-life balance. We are deeply committed to providing a workplace ambience that is both challenging and fulfilling.
Resourcesoft is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
For more information about Resourcesoft and our services, please visit our website.