Database Analyst

30 Sep 2024

Vacancy expired!

Description

Here are examples of responsibilities from real database analyst resumes representing typical tasks they are likely to perform in their roles.

Manage projects to upgrade PCs and software.Lead development and end-to-end implementation of CRM campaigns to grow and retain customer base.Manage contracted resources to provide initial setup of all databases, migrating complete financial records.Develop PL/SQL packages and procedures in order to automate financial reports on a monthly, quarterly and annual basis.Used T-SQL skills including creation of user define functions, complex store procedures, query optimization to write automate reporting.Plan GoldenGate setup to achieve unidirectional replication.Design and schedule SSIS packages to load data from OLTP to OLAP system for data analysis and generating KPI reports.Develop employee web portal using PHP, JavaScript, CSS, and MySQL.Extract information from various data sources and perform advanced data-cleansing using a combination of SQL and VBA codes (ETL).Used SSIS and T-SQL store procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.Develop SQL code in Teradata for customer lists for target marketing campaigns.Design, implement and maintain databases, including CDISC compliant database, for clinical trial studies.Design, code, and test new T-SQL functions and store procedures to meet new reporting needs.Review existing PL/SQL source code and database design to recommend improvements to enhance performance, storage, usability and system throughput.Design cloud architecture for highly-scaling, platform-agnostic system.

Requirements

Microsoft SQL, Microsoft Power BI, Power BI, Microsoft Excel, Excel Formulas

Technology Doesn't Change the World, People Do.®

Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Robert Half puts you in the best position to succeed by advocating on your behalf and promoting you to employers. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - even on the go. Download the Robert Half app and get 1-tap apply, instant notifications for AI-matched jobs, and more.

Questions? Call your local office at Robert Half will consider qualified applicants with criminal histories in a manner consistent with the requirements of the San Francisco Fair Chance Ordinance. All applicants applying for U.S. job openings must be authorized to work in the United States. Benefits are available to temporary professionals. Visit https://roberthalf.gobenefits.net/ for more information.

© 2022 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.

  • ID: #46114625
  • State: Texas San antonio 78230 San antonio USA
  • City: San antonio
  • Salary: $80000.00 to $90000.00 yearly
  • Job type: Permanent
  • Showed: 2022-09-30
  • Deadline: 2022-11-27
  • Category: Et cetera