\nSQL Server DBA / Developer, Boulder, Colorado or Remote for well qualified candidates\n\n \n\nYour Impact at Ascend Analytics\nAs a SQL Server DBA, Developer at Ascend Analytics, you will be part of a collaborative team advancing software solutions and analytics to support the clean-tech power revolution. Your strong software engineering skills will support mission critical decision analytics for renewable and battery storage power providers around the globe. If you want to help shape a new future of a cleaner, most cost-effective energy supply and work for an industry-leading software company with dedicated and talented people passionate about our future, this could be a great fit. Ascend is a fast growing and profitable company with opportunity for advancement.\n\nAscend Analytics is an innovative “climate tech” software and consulting company focused on energy analytics that are transforming the electric grid to renewables. Ascend's solutions provide the analytics to support critical power supply decisions from operating strategies over the next hour, to hedging and budgeting decisions over the next five years, to long-term investment and resource planning decisions over the next thirty years.\n\nFor more information, visit www.ascendanalytics.com\n\nJob Responsibilities\n\n\n* Design and write clean, scalable, production code with a majority focus on OLAP systems\n\n* Refactor code for improved performance, stability, and scalability\n\n* Implement systems for collecting, storing, and working with data at scale\n\n* Work with our team of developers, analysts and data scientists\n\n* Communicate clearly and effectively (orally and in writing) with both technical and nontechnical stakeholders\n\n* Contribute to scoping and design discussions\n\n* This position involves working collaboratively both within your software team and outside with the front-end software engineers, data scientists, and technical sales team. The software development team follows an agile scrum process, and all team members are expected to contribute to technical design reviews, implementation strategies, operational system support, and sprint planning.\n\n\n\n\n \n\nRequired Qualifications\n\n\n* Bachelor's degree in Computer Science, Physics, Mathematics, or another technical field\n\n* 3+ years development experience relevant to Business Intelligence\n\n* Microsoft SQL Server Analysis Services (SSAS), Complex SQL Language, MDX Language, and XMLA\n\n* Strong understanding of Data Warehouse/Solution Design and Dimensional Modeling\n\n* Strong understanding of Business Intelligence best practices, experience with Data Warehousing and OLAP databases, and defining, developing, and delivering data and analysis\n\n* Proficiency in OOP\n\n* Experience in Visual Studios Data Tools\n\n* Foundation in both Relational and Multidimensional Databases\n\n\n\n\n \n\n Preferred Qualifications\n\n\n* Strong background in programming related to applied mathematical, engineering, and physical sciences\n\n* Performance computing, including distributed and parallel computing technologies\n\n* Oracle and PL/SQL\n\n* Power BI experience\n\n* Ability to communicate with impact and confidence, both orally and in writing\n\n* Strong interpersonal skills, teamwork skills, and work ethic\n\n* Knowledge of wholesale electricity markets; passion for renewables and storage\n\n* Experience with code review, architecture, development, and promotion processes\n\n\n\nCompensation $100,000 - $150,000\n\nNegotiable based on qualifications and experience. Ascend highly values our employees and often pays above industry average.\n\nWe offer flexible work hours in a relaxed environment with opportunities for advancement and excellent benefits, including medical, dental, vision, short- and long-term disability, parental leave, dependent care spending account, and a 401k plan. \n\nWe celebrate diversity and are committed to creating an inclusive environment for all employees. Ascend Analytics is proud to be an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, sex (including pregnancy, childbirth or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, genetic information or other applicable legally protected characteristics.   \n\nAscend Analytics is committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, please contact us at [email protected]\n\n \n\n \n\n  \n\n#Salary and compensation\n No salary data published by company so we estimated salary based on similar jobs related to Design, Consulting and Sales jobs that are similar:\n\n $50,000 — $90,000/year\n
\n\n#Benefits\n 💰 401(k)\n\n🌎 Distributed team\n\n⏰ Async\n\n🤓 Vision insurance\n\n🦷 Dental insurance\n\n🚑 Medical insurance\n\n🏖 Unlimited vacation\n\n🏖 Paid time off\n\n📆 4 day workweek\n\n💰 401k matching\n\n🏔 Company retreats\n\n🏬 Coworking budget\n\n📚 Learning budget\n\n💪 Free gym membership\n\n🧘 Mental wellness budget\n\n🖥 Home office budget\n\n🥧 Pay in crypto\n\n🥸 Pseudonymous\n\n💰 Profit sharing\n\n💰 Equity compensation\n\n⬜️ No whiteboard interview\n\n👀 No monitoring system\n\n🚫 No politics at work\n\n🎅 We hire old (and young)\n\n
\n\n#Location\nBoulder, Colorado, United States

Roles and Responsibilities\n • Assess on-premises database environments such as Oracle or other Commercial DB Engines to Open Source Engines like Aurora-PostgreSQL/MySQL or RedShift, DynamoDB.\n • Oracle DB migration consulting with reduced TCO, HA, Agility, Security and Cloud adoption mindset\n • Engage with customers to develop an approach to migrate complex, on-premise landscapes to the cloud\n • Engage with customers to model and design their current state architecture, target state architecture, and transition architecture\n • Respond to detailed client and prospect proposals \n • Develop and deliver proof-of-concept projects, technical workshops, and support implementation projects to migrate Applications from Oracle databases to Oracle RDS, Aurora-PostgreSQL/MySQL or other Open Source platforms.\n • Collaborate with application developers and database administrators on projects and perform database code conversion like procedures, functions, and packages from one DB engine to another.\n • Develop and manage Database stored procedures, functions and batch programs\n • Perform database assessment, data mappings and migration using AWS SCT and DMS, Azure DMA and DMS and execute data assessment and migration projects.\n • Implementation and performance tuning experience of databases, including knowledge of schema design, query tuning and optimisation and integration\n • Create standard delivery artefacts (migration document, architecture diagrams, run books, backup/recovery plans, etc.) for migration and modernisation of databases\n • Perform homogenous and heterogenous DB migrations from on-prem to cloud, cloud to cloud\n • Use replication and data movement techniques. \n • Knowledge of Oracle Native methodologies for DB migration \n • Experience with tools like SCT, Fleet Advisor, and Database Migration Service (DMS)\n • Experience with Azure Data Migration Assistant (DMA), Azure DMS, SQL Server Migration Assistant (SSMA), Azure Synapse pathway \n\n Technical Expertise\n • 5 or more years of experience in Oracle database administration/development/modernisation\n • DBA experience on Oracle 19c/18c/12c on Linux & Windows on AWS\n • Demonstrate technical expertise in Oracle Apps system administration, including backup and recovery, database tuning and health checks, system installation, HA/DR, and security.\n • Strong experience in VM Infrastructure for running Oracle DB\n • Strong experience in Streams, Oracle RAC and Dataguard solution on-premises and on AWS cloud\n • Experience with Oracle migrations, upgrades, and high availability architectures.\n • Strong practical experience in Oracle DB performance tuning and database management\n • Strong experience in the database schema, code conversion, data conversion tools and methods\n • Good understanding of SQL, PL/SQL, and Shell scripting for Oracle\n • Performance tuning by database re-org, SQL query tuning, baselines, etc\n • Analyse SQL statement's cost, refactor and tune schema when necessary\n • Enhance maintenance procedures to improve Oracle AWS RDS performance like purging, archiving, and maintenance plans\n • Help with Project build, automation & Database migration support activities\n • Possess a good understanding of Oracle systems (Oracle E-Business suite, Oracle EPM, Hyperion, PeopleSoft, etc.).\n • Experience with migrating database environments from one platform to another\n • Strong experience in creating, testing and deploying new databases and performing data and DB code conversion across commercial (Oracle/MS SQL), open-source and cloud-native database engines\n • Strong skills, including writing Stored Procedures, Triggers, Views, Packages and User-defined functions.\n\n Good to Have\n • Executed at least 2 modernisation programs on heterogeneous DB migrations\n • Completed at least 2 sizeable (1- 10 TB) homogenous DB migrations\n • Strong experience with application/database re-platforming across operating systems and database engines\n • Knowledge of third-party Oracle solutions like Flashgrid\n • Strong experience in migration to cloud-native databases. e.g., AWS RDS, Azure SQL.\n • Experience in writing complex PL/SQL or PL/PgSQL stored procedures is highly desired \n • Experience in optimal design of database environments, analysing complex distributed production deployments, and making recommendations to optimise performance\n • Experience in AWS, Azure Platforms and Services \n • Experience in AWS and Azure Backup services\n\n Skills & Experience\n • Languages: SQL/PLSQL, Shell Scripting\n • Tools: SQL Developer, Putty, Terminal Services Client, Remote Desktop Connection\n • RDBMS: Oracle 12c, 18c, 19c\n • Cloud: AWS Oracle database builds and support\n • Operating System: Linux & Windows\n\n Preferred Technical and Professional Experience\n • Cloud Database Certifications – Oracle certified database associate/professional, AWS Certified Database Specialty\n Oracle 10g/11g/12c Certification is preferred\n\nAbout Rackspace Technology\nWe are the multicloud solutions experts. We combine our expertise with the world’s leading technologies — across applications, data and security — to deliver end-to-end solutions. We have a proven record of advising customers based on their business challenges, designing solutions that scale, building and managing those solutions, and optimizing returns into the future. Named a best place to work, year after year according to Fortune, Forbes and Glassdoor, we attract and develop world-class talent. Join us on our mission to embrace technology, empower customers and deliver the future.\n \n \nMore on Rackspace Technology\nThough we’re all different, Rackers thrive through our connection to a central goal: to be a valued member of a winning team on an inspiring mission. We bring our whole selves to work every day. And we embrace the notion that unique perspectives fuel innovation and enable us to best serve our customers and communities around the globe. We welcome you to apply today and want you to know that we are committed to offering equal employment opportunity without regard to age, color, disability, gender reassignment or identity or expression, genetic information, marital or civil partner status, pregnancy or maternity status, military or veteran status, nationality, ethnic or national origin, race, religion or belief, sexual orientation, or any legally protected characteristic. If you have a disability or special need that requires accommodation, please let us know. \n\n#Salary and compensation\n No salary data published by company so we estimated salary based on similar jobs related to Cloud, Backend, Amazon, SaaS, Engineer, Software, Marketing, Sales, Education, Developer, Senior, Digital Nomad, Architect, Drupal, iOS, Mobile, Junior, Excel, Legal, Developer, Travel, Analyst, Accounting, Salesforce, API, Linux, Teaching, Video, React, Microsoft, JavaScript, DevOps, Medical and Database Admin jobs that are similar:\n\n $70,000 — $120,000/year\n
\n\n#Benefits\n 💰 401(k)\n\n🌎 Distributed team\n\n⏰ Async\n\n🤓 Vision insurance\n\n🦷 Dental insurance\n\n🚑 Medical insurance\n\n🏖 Unlimited vacation\n\n🏖 Paid time off\n\n📆 4 day workweek\n\n💰 401k matching\n\n🏔 Company retreats\n\n🏬 Coworking budget\n\n📚 Learning budget\n\n💪 Free gym membership\n\n🧘 Mental wellness budget\n\n🖥 Home office budget\n\n🥧 Pay in crypto\n\n🥸 Pseudonymous\n\n💰 Profit sharing\n\n💰 Equity compensation\n\n⬜️ No whiteboard interview\n\n👀 No monitoring system\n\n🚫 No politics at work\n\n🎅 We hire old (and young)\n\n
\n\n#Location\nIndia - Remote