James Greaves Email & Phone Number

San Francisco, California, US

As a member of the ACME Data Management Services team (DMS) I work to build new and enhance existing data/information/and code application and data vault components. I am responsible for the creation, peer review, and implementation of SQL code, structure, and documentation of data artifacts for the Endpoint Data Vault (EDV) as well as the tool & reporting.

Madison, New Jersey, US

• Team leader within the data development capability repsonsible for real estate and property data:
• Implementation of cloud-based solutions using Azure SQL database.
• Development of stored procedures, views, and tables for ongoing database enhancements.
• Performance tuning and troubleshooting of SQL server performance issues in a high volume/high availability environment.
• Provide daily direction and guidance to team members on the development, maintenance, and support standards of the development team
• Synthesizing requirements from product owners and users to transform business rules into logical and physical designs within the data model.

Hanover, MD, US

Development of stored procedures, views, and tables for ongoing database development. Experience with support and administration of multi-database environments including SQL Clustering, Availability Groups, transactional replication, and Amazon Web ServicesPerformance tuning and troubleshooting of SQL server performance issues.

Hanover, MD, US

Consultant for various clients around the Minneapolis/St. Paul area.

Hanover, MD, US

• Working for 3M's commercial graphics division for the creation of a new product. SQL Server 2008 R2 development in the following areas:
• DBA designer of a VLDB for multi-tier web solution.
• Optimization of existing database solution by reviewing performance issues and improving stored procedures, SSIS packages, and reports to dramatically improve customer experience.
• Design, coding, and implementation of Business Intelligence ETL process to import client data into database system and aggregate the data into the data warehouse.
• Authored SQL Server configuration best practices document.
• Generation of coding practices document for consistency in the new product development.

Hanover, MD, US

• Working with the Wells Fargo Mortgage CODA (Common Online Data Analytics) team providing DTS/SSIS development for ETL process for their home mortgage data warehouse. Creation and design of SSIS packages, stored.
• Optimization of stored procedures, T-SQL, migration of DTS packages to SSIS packages, and streamlining of the overnight data processing for the data warehouse in the SQL Server 2005 environment.
• Importation and manipulation of data from heterogeneous systems consisting of Oracle, AS400, and mainframe flat files using best business intelligence practices via SSIS packages.

Hanover, MD, US

• Designed and implemented a new SQL 2005/2008 clustering solution to implement BizTalk, Team Foundation Server, and SharePoint, as well as the migration plan of data from existing Oracle databases.
• Created best practices document for future implementations of clustered environments.
• Mentored HB Fuller staff on SQL Server clustering best practices and common troubleshooting issues.

Hanover, MD, US

• Administration of SQL Server environment consisting of 100+ servers hosting 1500+ database for our customers
• Production support on vendor software packages as well as in house custom applications utilizing SQL Server.
• Performance tuning, troubleshooting, and implementation of new software packages as well as in house developed software running with a SQL 2000/2005 back end.
• Development in T-SQL for stored procedures, views, and ad-hoc queries for business needs

Hanover, MD, US

• Administration of SQL Server environment consisting of 90+ servers, clustered and non-clustered, located around the world
• Deployment of x64 SQL 2005 SQL server solution for mission critical application.
• Performance tuning, troubleshooting, and implementation of new software packages as well as in house developed software running with a SQL 2000/2005 back end.

Hanover, MD, US

Team lead of twelve DBAs guiding architectural design and implementation Performance tuning and troubleshooting of SQL server performance issues for twenty-five servers hosting over 150 databasesETL processing of flat file data from over 200 sources into a normalized database environment for online presentation on our B2C and B2B customers (Examples.

Hanover, MD, US

• Created triggers, stored procedures, data transformation packages for customer web sites
• Data modeling and optimization for in house custom CRM/data mining web applications
• Partnered with business analysts and developers to improve existing database architecture and SQL code for current business process
• Implemented database backup and disaster recovery procedure for the business
• Upgraded SQL 7.0 existing servers to SQL 2000

Hanover, MD, US

• Provided mission critical 24/7 support for large SQL Server environment (70 + servers of versions 6.5, 7.0 and 2000)
• Trained and mentored junior staff in SQL Server, development, methodologies and support
• Developed backup strategies and disaster recovery procedures for large business environment
• Provided project planning for change control in the SQL server environment
• Data modeling and optimization for existing applications as well as 3rd party customization of software packages
• Wrote T-SQL for triggers, stored procedures, data transformation packages and reporting

Minneapolis, MN, US

• Implementing and design of a new ETL process for Experian credit system to existing database system
• Creation and design of SSIS packages, stored procedures and table structures for a new revenue stream product for an existing system.
• Identification of all personal information within Bluestem databases for conversion to tokenized values. All personal SSN and drivers’ license information will be transferred to a central vault in the Enterprise. All.

Madison, NJ, US

• Team lead of twelve DBAs guiding architectural design and implementation
• Performance tuning and troubleshooting of SQL server performance issues for twenty-five servers hosting over 150 databases
• ETL processing of flat file data from over 200 sources into a normalized database environment for online presentation on our B2C and B2B customers (Examples provided upon request)
• Importation of RETS (Real Estate Transaction Service) via DTS data imports fourteen metro feeds
• Work estimation for DBA’s on team for Project Manager
• Interviewing DBA Candidates for positions with our company

Hastings, MN, US

North Melbourne, Victoria, AU

St Paul, MN, US

Montreal, Quebec, CA