We provide IT Staff Augmentation Services!

Ms Sql Database/engineer/architect And Application Administrator/support Resume

3.00/5 (Submit Your Rating)

San Antonio, TexaS

Hire Now

CAREER SUMMARY:

Over 20 years of experience in IT industry as SQL Server DBA/Engineer with multiple Development, Test and Production on Window Servers 2003/2008R2/2010. Experience includes 19 years working with System/Software applications administrator and design, over 10 years as a SQL Server Database Administrator and Software Development Life Cycle/Scrum/Agile.

EXPERIENCE:

Confidential, San Antonio, Texas

MS SQL Database/Engineer/Architect and Application Administrator/Support

Responsibilities:

  • Primary resource for creating/upgrading/modification/ETL of SSIS (DTS) packages/jobs/stored procedures and views from MS SQL Server, then to 2008 and 2008R2 utilizing SSMS/BIDS/(Visual Studio)/SSDT applications to adhere with business requirements to upgrade to SQL 2012/2014/2016 in a Rackspace cloud and MS Azure environment and data warehouse, with testing for latency issues.
  • Data Management, Active Directory Security, Linked Servers, and PowerShell/T - SQL scripting, VB, .Net, XML, HTML and C#.
  • Team lead responsible for all patches, upgrades, maintenance, and complete installs of SQL, using all (ERP) Enterprise Resource Plaining in a Scrum management/employee input environment, documented all transactions for team and management use.
  • Utilizing applications for analysis of upgrades from Microsoft, Programmatic Works Workbench, Apex, Redgate and Idera,
  • Create/Modify SSRS reports and control security access supporting Executive, Accounting, Sales and all employees to view all Retail Account Data/Consumer Relation Management, AX systems data.
  • Data integration with applications, Salient (Margin Minder), EZ Territory and Forecast software (TM1, Aras and SPSS).

Confidential, San Antonio, Texas

MS SQL/Oracle Database and Application Administrator/Support

Responsibilities:

  • Primary resource for creating/upgrading/modifying of SSIS (DTS) packages from MS SQL Server, then to 2008 and 2008R2 utilizing SSMS/BIDS (Visual Studio) applications to adhere to requirements and input data conversions (ETL), developing code with T-SQL, .NET, C# and VB from Microsoft Access, Excel, Oracle, SQL and SAS
  • Responsible for implementing SQL Server security including maintaining database authentication modes (Windows Active Directory/SQL Server) creation of users, configuring permissions and assigning roles and/or group to users
  • Over four years creating/modifying SSRS reports, SQL Mail Agent, Jobs and Alerts streamlining operations of operational tasks
  • Team lead responsible for all patches, upgrades, maintenance, and complete installs of SQL, Oracle and application software on Windows desktops, servers and HP/Linux hardware
  • Windows/Web Services administration on Microsoft Server 2003 R2 and 2008 R2 standalone, clustered and VMWare server environments
  • Create and maintain Maintenance Plans, Disaster Recovery, Backup, and Restores solutions for high availability of resources
  • Primary testers, installer and troubleshooting/diagnostic expert of SQL/Oracle 7.3/10g database software development/production tools

Confidential, San Antonio, Texas

Application Development Analyst

Responsibilities:

  • Created PL/SQL code producing customer and audit reports for two years
  • Supplied UNIX shell scripts reducing operator intervention for four years
  • Altered Oracle database tables with PL/SQL code improving production
  • Proficient with HTML/FRAME programming for WEB sit creation
  • Working knowledge with Windows 95/98/NT and DOS operating systems
  • Utilizing computer analysis positions supplied system administration ensuring all applications met job needs

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship